这种扫描只使用完整复合索引的子集。
This scan USES only subsets of the full range of a composite index.
该特性可以提高具有复合索引的表的查询性能。
This feature can improve query performance on tables with composite indexes.
使用复合索引键便可完成这项定义。
为此,索引列是一个包含索引的单列,或者是复合索引中指定的第一个列。
For this purpose, an indexed column is any single column with an index or the first column named in a composite index.
您会将复合索引键建立成匿名型别,或是包含要比较之值的具名型别。
You create a composite key as an anonymous type or named typed with the values that you want to compare.
优化器然后使用复合索引将临时表连接到事实表,来快速定位在维度表中满足条件的行。
The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
因为不能跨超类和子类的字段来建立复合索引,如果需要按这些列进行查询,性能会受影响。
Because you can't create a composite database index using columns across the super and a subclass, the performance will suffer if you need to query on such columns.
与RDBMS索引相似,可以使用多个属性创建复合索引,也可创建唯一索引,确保不存在重复的值。
Like RDBMS indexes, you can create compound indexes using multiple attributes, and unique indexes, which ensure that duplicate values are not allowed.
提出了一种语义向量算法,构建了图像语义关键词网络,实现了图像底层视觉特征和语义的复合索引。
The thesis presents a semantic vector algorithm, builds up the network of image semantic keywords, and realizes the composite retrieval of the image low-level feature and semantics characteristics.
顺序很重要,如果你的谓语以不同的顺序指定这些属性或在它们前罗列了其他属性,数据库就不会选择该复合索引。
The order is important because if your predicate specifies these properties in a different order or lists some other property before them, the composite index will not be selected by the database.
后端搜索器和UI搜索器区别太大,因此我们不得不为它构造另一个复合索引,依次使用isold、participantCode和transactionType。
The backend search is too different from the UI searches, so we had to make another composite index for it using the order isoId, participantCode and transactionType.
一般来说,如果内部索引是良好的集群且预测内部表被多次探测,则使用复合排序的嵌套循环联将受到优化器的青睐。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
简单的DCP可能存储在不止一个移动介质上(比如,复合式硬盘?)。这个索引文件用于识别整个DCP里的文件顺序。
A single DCP may be stored in more than one medium (e.g., multiple hard disks). This file is used to identify the volume order in the series.
简单的DCP可能存储在不止一个移动介质上(比如,复合式硬盘?)。这个索引文件用于识别整个DCP里的文件顺序。
A single DCP may be stored in more than one medium (e. g., multiple hard disks). This file is used to identify the volume order in the series.
算法的特性为现代网络搜索引擎的复合条件查询提供了有力的软件支撑。
The characteristics of this algorithm provide a powerful software sustentation for multicondition search of modern network search engines.
并在此模型上提出了一个基于R树的复合时空索引(CST-TREE)机制,定义了节点结构,并分析、描述了此索引的结构及原理。
On the basis of this model , the author put forward a R-tree based Composite Spatiotemporal Index (CST-TREE) and described its structure and mechanism.
该地理位置搜索引擎通过将代表搜索对象的多种属性的多个索引相复合构建而成。
The search engine for the geographical position is formed by compositely constructing a plurality of index phases representing a plurality of attributes of the search objects.
该地理位置搜索引擎通过将代表搜索对象的多种属性的多个索引相复合构建而成。
The search engine for the geographical position is formed by compositely constructing a plurality of index phases representing a plurality of attributes of the search objects.
应用推荐