20120524090343Heap-Organized-table-和-Index-Organized-table-说明 Heap-Organized-table-和-Index-Organized-table-说明 Heap-Organized-table-和-Index-Organized-table-说明
Heap-Organized table 和 Index-Organized table 说明Heap-Organized table 和 Index-Organized table 说明
分类: 默认分类
日期: 2011-05-24 21:29
原文地址: doc.guandang.net 分类: Oracle 基础知识 2011-05-24 21:29 703人阅读 评论(0) 收藏 举报
官网的两个连接如下:
Tables and Table Clusters
doc.guandang.net
Indexes and Index-Organized Tables
doc.guandang.net
这2个文章讲的比较详细,在这里我将一些内容粘贴出来。
You can create a relational table with the following organizational characteristics:
(1)A heap-organized table does not store rows in any particular order. The CREATE TABLE statement creates a heap-organized table by default.
(2)An index-organized table orders rows according to the primary key values. For some applications, index-organized tables enhance performance and use disk space more efficiently. See "Overview of Index-Organized Tables".
Rowid Data Types
Every row stored in the database has an address. Oracle Database uses a ROWID data type to store the address (rowid) of every row in the database. Rowids fall into the following categories:
(1)Physical rowids store the addresses of rows in heap-organized tables, table clusters, and table and index partitions.
(2)Logical rowids store the addresses of rows in index-organized tables.
(3)Foreign rowids are identifiers in foreign tables, such as DB2 tables accessed through a gateway. They are not standard Oracle Database rowids.
A data type called the universal rowid, or UROWID, supports all kinds of rowids.
Use of Rowids
Oracle Database uses rowids internally for the construction of indexes. A B-tree index, which is the most common type, contains an ordered list of keys divided into ranges. Each key is associated with a rowid that points to the associated row's address for fast access. End users and application developers can also use rowids for several important functions:
(1)Rowids are the fastest means of accessing particular rows.
(2)Rowids provide the ability to see how a table is organized.
(3)Rowids are unique identifiers for rows in a given table.
You can also create tables with columns defined using the ROWID data type. For example, you can define an exception table with a column of data type ROWID to store the rowids of rows that violate integrity constraints. Columns defined using the ROWID data type behave like other table columns: values can be updated, and so on.
Overview of Table Clusters
A table cluster is a group of tables that share common columns and store related data in the same blocks. When tables are clustered, a single data block can contain rows from multiple tables. For e
比如 CQI=2,选定确定 MCS=0,进而确定采用 QPSK 调制,并且选择 TBS index=0,再查 3GPP TS 36.213 table 7.1.7.2.1-1,得到 20M 小区带宽下 TBS=2792,...
简述Oracle IOT(Index Organized Table)_计算机软件及应用_IT/计算机_专业资料...dbms_stats.gather_table_stats(user,'T_HEAP',cascade => true); PL/SQL ...
heap file organization , sequential file ... which is organized as a sequential file, taking...It is required that the index file and index ...
(n-D) Lookup Table Dynamic PreLookup Index Search Sine 6.数学模块 Math Operations 名称 Abs Add Algebraic Constraint Assignment Bias Complex to Magnitude-...
“Bind Columns”按钮; 对话框的 按钮 单击“ 对话框的“ 单击“Bind Rule to Columns”对话框的“Table”下拉按 对话框的 下拉按 选择数据表; 钮,选择数据表...
create a heap table with rowid to store the ...EMPLOYEES tab le as an index-organized (IOT). ...ORDERS table as an i ndex-organized table (IOT...
TSA-230ADVI 压缩机使用维护说明书 TSA-230ADVI Main compressor description 12 其他 Other 无 None 13 缩写和索引 Abbreviation and index 无 None 文件名称:TSA...
如果是一般的 Heap Table,新的分区 indexes 为 UNUSABLE ,所有 gloabl indexes 被标识为 UNUSABLE 。 如果是 Index-organized table 新分区的 indexes 为 UNUSABLE...
(Index-OrganizedTables)、堆组织表(Heap-OrganizedTables),但不支持段压缩(...TABLE_NAMEFROMDBA_LOGSTDBY_NOT_UNIQUEWHERE(OWNER,TABLE_N AME)NOTIN(SELECT...
堆(heap)是一组空间,以一种有些随机的方式使 用。 528 / 976 q 索引组织表(index organized table):这些表按索引结构存储。这就强制要求行本身有某 种物理...
热门文档