An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
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.
该查询计划显示索引扫描使用了函数索引。
Finally, execute a query that USES the functional index.
最后,执行查询,该查询将使用函数索引。
The data type of the index matches the data type in the query predicate.
索引的数据类型与查询谓词的数据类型相匹配。
The GAE datastore leverages an index for any query issued.
GAE数据存储对发出的任何查询使用索引。
A new feature of the query optimizer supports a new type of index scan, called an index self-join path.
查询优化器的一项新特性支持一种新的索引扫描,即索引自连接路径。
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.
另一方面,数据库是一个容 易做一些简单改变(添加一个索引,稍稍修改一个查询)并看到巨大性能改善的地方。
Furthermore, if indexes already exist for both columns (one for EMPNO and one for DEPTNO), DB2 can use them both to satisfy this query so creating another index might not be necessary.
而且,如果已经存在关于这两列的索引(一个关于EMPNO,一个关于DEPTNO),DB 2可以使用它们来满足该查询,因此创建另一个索引也许是没有必要的。
The final query is the query that exploits the extended index.
最后的查询是利用扩展的索引的查询。
GAE requires that all the data columns involved in a query be indexed, and the index can't contain BLOB or text columns.
GAE需要将查询中涉及到的所有数据列编入索引,且该索引不包含BLOB或文本列。
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.
用以读取叶子页面的成本取决于索引的大小、查询的筛选器以及索引的惟一性。
A query is often slow because it has no index or an inefficient 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.
未使用反向文本索引的查询的访问计划。
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数据。
应用推荐