Format of Index Blocks (207)
Space available for index data is the Oracle block size minus block overhead, entry
overhead, rowid, and one length byte for each value indexed.
When you create an index, Oracle fetches and sorts the columns to be indexed and
stores the rowid along with the index value for each row. Then Oracle loads the index
from the bottom up. For example, consider the statement:
CREATE INDEX employees_last_name ON employees(last_name);
Oracle sorts the employees table on the last_name column. It then loads the index
with the last_name and corresponding rowid values in this sorted order. When it
uses the index, Oracle does a quick search through the sorted last_name values and
then uses the associated rowid values to locate the rows having the sought last_
name value.
索引格式
1. 索引資料段可用空間由資料塊大小減去塊開銷 , 條目開銷 ,rowid , 索引長度值(1位)
2. 建立索引的時候 ,Oracle取得並排序要建立索引的列 ,
將rowid和索引值儲存起來按從下到上的順序載入到索引中
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982563/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Blocks Programming Helper ↗ Blocks in System APIsBloCAPI
- JavaScript需要BlocksJavaScriptBloC
- Format and un-format money/currency in JavaScriptORMJavaScript
- Blocks的實現BloC
- Overview of Data Blocks(二)ViewBloC
- Dumping Oracle BlocksOracleBloC
- dba_tables.blocks、dba_tables.empty_blocks和dba_segments.blocks之間是什麼關係BloC
- (譯)窺探Blocks(2)BloC
- iOS-Blocks學習iOSBloC
- Code::Blocks Debug配置BloC
- (譯)窺探Blocks (1)BloC
- LeetCode 207 Course ScheduleLeetCode
- Error format not a string literal and no format arguments解決方案ErrorORM
- Mysql date_format 與 Oracle to_char(date,’format’)MySqlORMOracle
- 'format' 詳解ORM
- SUN format命令ORM
- set excel formatExcelORM
- Json formatJSONORM
- 求助:TypeError: unsupported format string passed to NoneType.__format__ErrorORMNone
- [linux]安裝code::blocksLinuxBloC
- Autonomous PL/SQL Blocks (151)SQLBloC
- oracle工具 awr formatOracleORM
- vim Google style formatGoORM
- MYSQLDUMP TABLE IN SQL FORMATMySqlORM
- [Ruby]format xml with RubyORMXML
- Blocks深入理解和詳解BloC
- Code::Blocks專案配置基礎BloC
- ErrorException In FilesystemAdapter.php line 207ErrorExceptionAPTPHP
- KEEP INDEX | DROP INDEXIndex
- 問題解決:TypeError: unsupported format string passed to NoneType.__format__ErrorORMNone
- LeetCode 207. 課程表(Medium)LeetCode
- 【暴力】codeforces 838A Binary BlocksBloC
- 用code::blocks寫C/C++程式BloCC++
- Named vs Anonymous Pl/sql Blocks testingSQLBloC
- dumping_oracle_blocks翻譯(二)OracleBloC
- Why should we copy blocks rather than retain?BloCAI
- code::blocks不能除錯的可能原因BloC除錯
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST