顺序很重要,如果你的谓语以不同的顺序指定这些属性或在它们前罗列了其他属性,数据库就不会选择该复合索引。
The order is important because if your predicate specifies these properties in a different order or lists some other property before them, the composite index will not be selected by the database.
但是,如果没有数据分布,则数据库服务器根据表索引计算不同类型的过滤器的选择率。
However, in the absence of data distributions, the database server calculates selectivity for filters of different types based on table indexes.
对于要由层次体系中具有不同权限级别的用户所访问和编辑的数据,某种形式的数据库是惟一的选择。
For data that is accessed and edited by many different users with varying levels of privilege across heterogeneous systems, a database of some kind is the only option.
应用推荐