普通索引 meaning in English
simple index
Examples
- Several regular indexes allowed per table
每个表允许有若干个普通索引。 - Partitioned indexes are created and maintained in a similar manner to partitioned tables , but like ordinary indexes , they are handled as separate database objects
创建和维护已分区索引的方式与已分区表相同，但与普通索引一样，将已分区索引作为单独数据库对象来进行处理。 - In a quick test on a table with 100 , 000 rows loaded using a sequence , a normal index was used for most queries returning up to 30 rows , as was the reverse key index , however , when the number of rows went up to 1 , 000 , 000 the reverse key index was never used and a full table scan was used every time
在一个用一个序列载入并含100 , 000行的表上做一个快速的测试，分别用普通索引和逆序索引查询并返回30行数据，当行数增长到1 , 000 , 000 ，将不再使用逆序索引而是每次使用全表扫描。