CREATE UNIQUE INDEX uk_staff_name ON t_staff(staff_name); -- 创建唯一索引 CREATE BITMAP INDEX idx_gender ON t_staff(gender); -- 创建位图索引 ..
基于1个网页-相关网页
与RDBMS索引相似，可以使用多个属性创建复合索引，也可创建唯一索引，确保不存在重复的值。
Like RDBMS indexes, you can create compound indexes using multiple attributes, and unique indexes, which ensure that duplicate values are not allowed.
然而，由于xml列不属于表分区键的一部分，任何唯一xml值索引必须创建为全局索引。
However, since XML columns cannot be part of the table partitioning key, any unique XML values index will have to be created as a global index.
为每一行数据所创建的索引成为了计数器，因为每当新的一行数据加进来的时候，这个索引是唯一的增量，这也意味着计数器将与字符串数据的总量同步变化。
The index created for each row of data becomes the count because it was only incremented when a new row of data was found, meaning it is in sync with the amount of data in the string.
应用推荐