Format of Index Blocks【每日一译】--20121214
来源:互联网 发布:发布淘宝类目如何选择 编辑:程序博客网 时间:2024/05/01 19:32
Space available for index data is the Oracle block size minus block overhead, entry
stores the rowid along with the index value for each row. Then Oracle loads the index
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_
overhead, rowid, and one length byte for each value indexed.
When you create an index, Oracle fetches and sorts the columns to be indexed andstores the rowid along with the index value for each row. Then Oracle loads the index
from the bottom up. For example, consider the statement:
对于索引数据的可用空间等于ORACLE块大小减去块的消耗,条目消耗,ROWID,和对于每个索引化值的长度字节。
当你创建一个索引,ORACLE获取并且排序索引化的列并且存储每行的索引值相关的ROWID。然后ORACLE加载索引
从底部向上。比如,确认以下的语句:
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.
ORACLE排序EMPLOYEES表在LAST_NAME列上。然后它加载关于LAST_NAME和对应ROWID值的索引以这样的排序
顺序。当使用索引时,ORACLE执行一个快速查找通过排序LAST_NAME值和使用ROWID值相关去定位被查找的名的值
的行。
- Format of Index Blocks【每日一译】--20121214
- Overview of Index-Organized Tables【每日一译】--20121231
- Benefits of Index-Organized Tables【每日一译】--20130101
- Monitoring Index Usage【每日一译】--20121216
- Index Range Scan【每日一译】--20121221
- Row Format and Size【每日一译】--20121123
- Release Number Format --每日一译【2013-01-28】
- Rebuilding an Existing Index【每日一译】--1215
- index in array-AWK碎片【每日一译】--20130203
- 每日一坑 pyinstaller 将.py生成.exe 报错 “IndexError: tuple index out of range”
- Overview of Dimensions【每日一译】--20121206
- Overview of Synonyms【每日一译】--20121208
- Overview of Indexes【每日一译】--20121209
- Introduction to Data Blocks, Extents, and Segments【每日一译】--2012-10-16
- Overview of Data Blocks【每日翻译】--2012-10-18
- 每日一练——H-Index
- Content of the PGA【每日一译】--2012-10-10
- Overview of Oracle Processes【每日一译】--2012-10-11
- xinit启动X Window System过程初探
- 用短信进行分享一段文字
- CheckBox的全选与不全选(刷新页面效果)
- CheckBox全选与不全选(不用刷新页面)
- 注册页面完成。自动给所有邮箱发送激活邮件
- Format of Index Blocks【每日一译】--20121214
- Mysql Java 连接指导
- 在 javascript 中,为什么 [1,2] + [3,4] 不等于 [1,2,3,4]?
- java 内存检测工具
- 省市县三级联动
- django中遇到的错误及解决方案
- objective-c中的构造函数(对象初始化)(七)
- Sql Server 2005中的架构(Schema)、用户(User)、登录(Login)和角色(Role)
- 13_JavaWeb综合实例