using an index meaning in Chinese
使用索引
学用索引
Examples
- The query optimizer uses this statistical information to determine the optimal query plan by estimating the cost of using an index to evaluate the query
查询优化器使用这些统计信息并通过估计使用索引评估查询的开销来确定最佳查询计划。 - For example , some . net framework methods and properties use an index to designate a character in a string or an element in an array or collection
例如,某些. net framework方法和属性使用索引指定字符串中的某个字符或数组或集合中的某个元素。 - The logic used by the sql server query optimizer to decide when to use an indexed view is similar to the logic used to decide when to use an index on a table
Sql server查询优化器用于决定何时使用索引视图的逻辑与用于决定何时对表使用索引的逻辑相似。 - When the query optimizer uses an index , it searches the index key columns , finds the storage location of the rows needed by the query and extracts the matching rows from that location
查询优化器使用索引时,搜索索引键列,查找到查询所需行的存储位置,然后从该位置提取匹配行。 - However , for the optimizer to consider indexed views for matching or use an indexed view that is referenced with the noexpand hint , the following set options must be set to on
但是,为了使优化器考虑使用索引视图进行匹配或在引用索引视图时使用noexpand提示,必须将以下set选项设置为on :