New features added to query time performance are as follows.
查询中增加的新特性列举如下。
The ability to load data into HashMaps where column names are not known at query time.
将数据加载到HashMaps 的功能(在查询时列名是未知的)。
To check if a spatial grid index is actually exploited during query time, you should have a look at the access plan.
为检查在查询时是否真正使用了一个空间网格索引,应该查看一下访问计划。
The effects of clustering the rows by their spatial properties rely on accessing just a subset of the data during query time.
按照空间属性聚集这些行的效果取决于在查询时对一个数据子集的访问。
Turn off any features you are not in fact using. If you are storing fields but not using them at query time, don't store them.
如果你存储了字段,但是在查询时根本没有用到它们,那么别存储它们。
This paper presents an algorithm to dispatch the operations of the query tree, parallelize queries, and shorten the query time.
针对这种情况,本文提出一种对数据库查询树的分配算法,使查询并行化,缩短查询的响应时间。
XQuery over XML data in XML type columns can be 40 times faster than corresponding queries over CLOB columns which require XML parsing at query time.
xml类型列中XML数据的XQuery速度比CLOB的对应查询(需要在查询时进行xml解析)速度快了40倍。
Using a text index makes document search much more efficient, as the text data does not need to be examined at query time like it is done with sub-string matching.
使用文本索引使文档搜索的效率大大提高,因为不需要像进行子字符串匹配时那样在查询时检查文本数据。
Using a text index makes document search much more efficient, as the text data does not need to be examined at query time like it is done with sub-string matching.
使用文本索引使文档搜索的效率大大提高,因为不需要像进行子字符串匹配时那样在查询时检查文本数据。
应用推荐