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.
您要决定字段是否拥有索引,如果是的话,那么查询是否能够有效地使用索引。
So we create a spatial grid index that will be used at query time.
所以我们创建一个空间网格索引,这个索引将在查询时用到。
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.
最后,执行查询,该查询将使用函数索引。
The data type of the index matches the data type in the query predicate.
索引的数据类型与查询谓词的数据类型相匹配。
With the step-by-step analysis on statistics, predicate, and index, the performance of the problem query is improved significantly.
通过对统计数据、谓词和索引的逐步分析,问题查询的性能大幅提升。
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.
最后的查询是利用扩展的索引的查询。
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 an inverted text index.
访问反向文本索引的查询的访问计划。
Access plan for query accessing a hash index.
访问hash索引的查询的访问计划。
Access plan for query without inverted text index.
未使用反向文本索引的查询的访问计划。
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。
Access plan for query without hash index.
不使用hash索引的查询的访问计划。
But there's no data in the Solr index to manage or query - yet.
但是Solr索引中还没有数据可供管理或查询。
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对象。
应用推荐