How Indexes Are Stored (206)
When you create an index, Oracle automatically allocates an index segment to hold the
index’s data in a tablespace. You can control allocation of space for an index’s segment
and use of this reserved space in the following ways:
■ Set the storage parameters for the index segment to control the allocation of the
index segment’s extents.
■ Set the PCTFREE parameter for the index segment to control the free space in the
data blocks that constitute the index segment’s extents.
The tablespace of an index’s segment is either the owner’s default tablespace or a
tablespace specifically named in the CREATE INDEX statement. You do not have to
place an index in the same tablespace as its associated table. Furthermore, you can
improve performance of queries that use an index by storing an index and its table in
different tablespaces located on different disk drives, because Oracle can retrieve both
index and table data in parallel.
索引如何儲存
1. 透過下列方式控制索引段的空間分配和使用
a. 設定索引段的儲存引數來控制如何為此索引段分配資料擴充套件
b. 為索引段設定 PCTFREE 引數,來控制組成資料擴充套件的各個資料塊的可用空間情況。
2. Oracle能並行的retrieve索引和表 , 所以將索引和表放在不同的兩個物理磁碟上可改進效能
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982560/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How Views are Stored (175)View
- How to rename an Oracle stored procedureOracle
- How Indexes Grow and PctfreeIndex
- How to use sql result stored on shell variable?SQL
- Rebuild IndexesRebuildIndex
- ORACLE INDEXESOracleIndex
- Oracle stored procedure to send emailOracleAI
- Oracle - Tables/IndexesOracleIndex
- Reverse Key IndexesIndex
- ORACLE -> NULL & INDEXESOracleNullIndex
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Global Nonpartitioned IndexesIndex
- Extents in Indexes (19)Index
- execute shell script from stored procedure
- 翻譯(九)——Clustered Indexes: Stairway to SQL Server Indexes Level 3IndexAISQLServer
- skip_unusable_indexesIndex
- The Secrets of Oracle Bitmap IndexesOracleIndex
- Restrictions on Create Bitmap IndexesRESTIndex
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- Overview of Indexes (194)ViewIndex
- Indexes and Nulls (198)IndexNull
- 【PLAN STABILITY】 STORED-OUTLINE
- stored procedure 收集session wait 資訊SessionAI
- Result Sets from Stored Procedures In Oracle (轉)Oracle
- stored procedure 收集session wait 資訊(轉)SessionAI
- Sparse Indexes vs unique indexIndex
- SKIP_UNUSABLE_INDEXES InitializationIndex
- Choosing Composite IndexesIndex
- 建立Function-Based IndexesFunctionIndex
- Bitmap Indexes and Nulls (224)IndexNull
- Partitioned Indexes on Composite PartitionsIndex
- 慎用 skip_unused_indexesIndex
- Delete indexes to free database.deleteIndexDatabase
- Unique and Nonunique Indexes (195)Index
- Composite Indexes (196)Index