An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
To ensure that we got meaningful results, we also verified that the grid index is actually exploited for this query as explained in a later section.
为了确保能得到有意义的结果,我们还像后面一个小节中解释的那样,检验网格索引是否真正被用于这个查询。
With this feature, the query optimizer can immediately consider the index when determining an access plan.
有了这个特性,查询优化器可以在决定访问计划时立即考虑索引。
Determine whether a field has an index and, if so, whether the query can efficiently use the index.
您要决定字段是否拥有索引,如果是的话,那么查询是否能够有效地使用索引。
However, the query parser is not thread safe, so each thread using the index should have its own query parser.
不过怎样,查询刨析器不是线程级安全的,所以每个使用索引的线程都需要有自己的查询刨析器。
Abbreviations must be added to a synonym dictionary to be mapped to the full term for index and query processing.
缩写词必须添加到同义词词典中才能映射到索引和查询处理的完整词汇。
Range producer function to define the search ranges for the spatial index during query execution.
用于定义在查询执行期间空间索引的搜索范围的范围生成器函数。
This query plan shows the use of a functional index.
该查询计划展示了函数索引的使用。
This query plan shows an index scan using our functional index.
该查询计划显示索引扫描使用了函数索引。
To check if a spatial grid index is actually exploited during query time, you should have a look at the access plan.
为检查在查询时是否真正使用了一个空间网格索引,应该查看一下访问计划。
Finally, execute a query that USES the functional index.
最后,执行查询,该查询将使用函数索引。
With the step-by-step analysis on statistics, predicate, and index, the performance of the problem query is improved significantly.
通过对统计数据、谓词和索引的逐步分析,问题查询的性能大幅提升。
The XML index definition is equally or less restrictive than the query predicate (" containment ").
xml索引定义的限制等同于或低于查询谓词的限制(“容纳”)。
The GAE datastore leverages an index for any query issued.
GAE数据存储对发出的任何查询使用索引。
Any query that utilizes the Primary Index column will encounter faster response times.
任何利用主索引列的查询将会遭遇更快速响应时间问题。
The database, on the other hand, is an easy place to make a few simple changes (add an index, change a query slightly) and see tremendous performance improvements.
另一方面,数据库是一个容 易做一些简单改变(添加一个索引,稍稍修改一个查询)并看到巨大性能改善的地方。
Figure 17 shows the index recommendations for the sample query in this article, together with an estimated performance improvement and DASD space requirement.
图17显示了本文中查询样例的索引建议,以及估计的性能提升和DASD空间需求。
The final query is the query that exploits the extended index.
最后的查询是利用扩展的索引的查询。
Comparing the access plans in Figure 4 and Figure 5 shows again with the EISCAN operator that an extended index is used by the query.
比较图4和图5中的访问计划,会发现对于EISCAN操作符,查询使用了一个扩展索引。
The costs used to find a leaf page depends on the size of the index, the filer of the query, and the uniqueness of the index.
用以读取叶子页面的成本取决于索引的大小、查询的筛选器以及索引的惟一性。
Database index is critical to query performance.
数据库索引对于查询性能来说十分关键。
Query Tuner also provides index advice.
QueryTuner还提供索引建议。
Access plan for query accessing a hash index.
访问hash索引的查询的访问计划。
The leftmost plan (a) is used if there is no eligible index for the predicates in this query.
如果该查询中没有合适的索引用于谓词,则使用最左边的计划(a)。
Actually, they are the index Numbers returned by my query to my local copy of the WordNet database.
实际上,它们是我对我的WordNet数据库本地副本的查询返回的索引数字。
To store, index, and query well-formed XML conforming to specific XML schemas in a uniform way.
以统一的方式存储、索引和查询符合特定XML模式的格式良好的XML。
To store, index, and query XML easily without needing to convert the XML (shred) to relational format.
无需将XML(分解)转换为关系格式,即可轻松存储、索引和查询XML。
As an alternative to shredding, you can simply use a table with a column of type XML to store, index, and query the MIML data.
作为分解的备选方法,可以简单地使用一个包含xml列的表来存储、索引和查询MIML数据。
The IndexSearcher does the actual munging through the index, but it only understands Query objects.
IndexSearcher通过索引munging,但它只理解Query对象。
Solr also provides a master-slave index replication mechanism to allow query load to be distributed in a large-scale environment.
Solr还提供了主-从索引复制机制,以便在大规模的应用中分散查询负载。
应用推荐