文档库

最新最全的文档下载
当前位置:文档库 > manage index

manage index

Objectives

manage index

分类

- 逻辑

Single column or concatenaed

Unique or nonunique

function-based

domain ( 使用比较少,索引数据库以外的数据)

- 物理

分区表或非分区表

B-tree : Normal or reverse key ( 使用最多) B – balance - 平衡树

Bitmap

manage index

首先, 索引本身也要有存储的位置和结构.

Although all the indexes use a B-tree structure, the term B-tree index is usually associated with an index that sotres a list of ROWIDS for each key.

manage index

(共13页)