unique 是指值不可重复的索引,是用B*树来保存的。
bitmap 一般用于值重复率很高的索引,如性别字段只有男、女两种选项。
bitmap 一般用于值重复率很高的索引,如性别字段只有男、女两种选项。
解决方案 »
- 新人小问题求指教
- rman备份与恢复必须在归档模式下吗
- System.DllNotFoundException: 无法加载 DLL“OraOps10.dll
- 磁头寻道到目标数据块时速度会降低吗?
- oracle 删表无敌慢!请指点!
- 非顺序插入表中 ROWNUM用来排序不准确
- oracle 9i 在安装到Oracle Database Configuration assistant....的时候装不下去了,等了2个小时没有反应,也没有错误提示?请教大侠是怎
- oracle有没有布尔型数据类型啊????
- 求助:忘了ORACLE ENTERPRISE MANAGER CONSOLE的登陆名及密码怎么办?
- 欢迎大家讨论一下:查询月记录的最佳方法。
- oracle的OracleszhoraHTTPServer服务强占了我的80端口,,怎样改过来??
- 请各位大侠帮忙:怎样用sql 把一个表空间中的表复制到另一个表空间?
Specify UNIQUE to indicate that the value of the column (or columns) upon which the index is based must be unique. If the index is local nonprefixed (see local_partitioned_index), then the index key must contain the partitioning key.BITMAP
Specify BITMAP to indicate that index is to be created with a bitmap for each distinct key, rather than indexing each row separately. Bitmap indexes store the rowids associated with a key value as a bitmap. Each bit in the bitmap corresponds to a possible rowid, and if the bit is set, it means that the row with the corresponding rowid contains the key value. The internal representation of bitmaps is best suited for applications with low levels of concurrent transactions, such as data warehousing.
--------------------------------------------------------------------------------
Note:
Oracle does not index table rows in which all key columns are null except in the case of bitmap indexes. Therefore, if you want an index on all rows of a table, you must either specify NOT NULL constraints for the index key columns or create a bitmap index.