The table is logically joined to itself, and the more selective non-leading index keys are applied as index bound filters to each unique combination of the leading key values.
首先在逻辑上将表与其自身连接,然后将更具有选择性的非起始索引键作为索引绑定过滤器,应用于起始键值的每个惟一的组合。
For example, non-unique element names can keep you from properly evaluating code that performs fewer index look-ups.
例如,非唯一元素能够阻止您正确评估执行较少索引查询的代码。
There are two types of Primary Indexes - unique Primary Index (UPI) and Non-unique Primary Index (NUPI).
有两种主索引—惟一主索引(upi)与非惟一主索引(NUPI)。
Index options like UNIQUE and CLUSTER, and access methods like B-Tree, R-Tree and user-defined access methods can apply to both functional and non-functional indexes.
诸如unique和CLUSTER等索引选项,以及B -Tree、r -Tree等访问方法和用户定义的访问方法,可以同时应用于函数索引和非函数索引。
Index options like UNIQUE and CLUSTER, and access methods like B-Tree, R-Tree and user-defined access methods can apply to both functional and non-functional indexes.
诸如unique和CLUSTER等索引选项,以及B -Tree、r -Tree等访问方法和用户定义的访问方法,可以同时应用于函数索引和非函数索引。
应用推荐