文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > Heap-Organized-table-和-Index-Organized-table-说明
侵权投诉

Heap-Organized-table-和-Index-Organized-table-说明

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

第1页

你可能喜欢

热门文档

相关文档

  • TD-LTE CQI计算说明20130709

    比如 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)

    简述Oracle IOT(Index Organized Table)_计算机软件及应用_IT/计算机_专业资料...dbms_stats.gather_table_stats(user,'T_HEAP',cascade => true); PL/SQL ...

  • 2008年《数据库系统原理》试卷-A卷-试题-答案-B5-v3(邓...

    heap file organization , sequential file ... which is organized as a sequential file, taking...It is required that the index file and index ...

  • MATLAB-simulink模块说明

    (n-D) Lookup Table Dynamic PreLookup Index Search Sine 6.数学模块 Math Operations 名称 Abs Add Algebraic Constraint Assignment Bias Complex to Magnitude-...

  • 13--默认和规则

    “Bind Columns”按钮; 对话框的 按钮 单击“ 对话框的“ 单击“Bind Rule to Columns”对话框的“Table”下拉按 对话框的 下拉按 选择数据表; 钮,选择数据表...

  • oracle-ocp-043试题分类汇总

    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...

  • K83 TSA-230ADVI使用维护说明书2.0中英文版(2009.11.30...

    TSA-230ADVI 压缩机使用维护说明书 TSA-230ADVI Main compressor description 12 其他 Other 无 None 13 缩写和索引 Abbreviation and index 无 None 文件名称:TSA...

  • Oracle分区表 (Partition Table) 的创建及管理

    如果是一般的 Heap Table,新的分区 indexes 为 UNUSABLE ,所有 gloabl indexes 被标识为 UNUSABLE 。 如果是 Index-organized table 新分区的 indexes 为 UNUSABLE...

  • Oracle-Data-Gurad---Logical-Standby-相关说明

    (Index-OrganizedTables)、堆组织表(Heap-OrganizedTables),但不支持段压缩(...TABLE_NAMEFROMDBA_LOGSTDBY_NOT_UNIQUEWHERE(OWNER,TABLE_N AME)NOTIN(SELECT...

  • 数据库中的表

    堆(heap)是一组空间,以一种有些随机的方式使 用。 528 / 976 q 索引组织表(index organized table):这些表按索引结构存储。这就强制要求行本身有某 种物理...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email