注意:当索引表达式被用于关系表达式,或作为某个操作符类函数的参数时,查询优化器将考虑使用函数索引。
Note: the query optimizer considers using a functional index when the index expression is used in a relational expression or as an argument to one of the operator class functions.
这是一种新型表达式语言,拥有优秀的集合、对象图遍历和索引支持功能。
This is the newer form of expression languages and has excellent collection, object graph traversal, and indexing support.
全文本索引迅速找到这些XML文档,随后将它们输入到从这些文档中提取所有员工姓名的FL WOR表达式中。
The full-text index finds these XML documents quickly which are then input to the FLWOR expression that extracts all employee names from these documents.
此外,星号可以用于作为通配符来匹配多个节点,括号内的表达式可以用于匹配属性值和规定索引。
In addition, asterisks can be used as wildcards to match multiple nodes, and bracketed expressions can be used to match attribute values and specify indices.
尽管清单34中的表达式能够工作,但是使用慎重应用的括号则更为清晰,并且容易改编来选择第二个、第三个或者任何其他索引。
Although the expression in Listing 34 works, using carefully applied parentheses does the job more cleanly and is easily adapted to select the second, third, or any other index.
展示如何创建xml索引以及如何使用DAD中的信息创建索引的XML表达式。
Show how to create XML indexes and how to use information in the DAD to create the XML expression for the index.
算术表达式包含START _ date列使得谓词不可索引。
The arithmetic expression involving the START_DATE column makes the predicate non-indexable.
如果会绕过索引,应该对比较表达式的RHS执行类型转换。
If the index is being bypassed, then the RHS of the comparison should be type-cast.
表示想要的对象在序列中的索引的整数(或计算出整数的表达式)。
An integer (or an expression that evaluates to an integer) that represents the index of the desired object in the series.
这说明,该函数必须在一个涉及比较操作并且引用了索引扩展hash _ index的搜索方法“equals”的表达式中使用。
It says that the function must be used in an expression involving the comparison operation and that the search method "equals" of the index extension hash_index is referred to.
与在单个dbspace中保存多个表或索引片段提高了查询性能,这样做胜过将每个分段表达式存储在不同的dbspace中。
Storing multiple table or index fragments in a single dbspace improves query performance over storing each fragmented expression in a different dbspace.
当一个LINQ表达式直接访问数据库时,DLINQ Provider支持所有数据库索引。
When a LINQ expression directly targets a database, the DLINQ provider has full access to the database's indexes.
在很多情况下,原生xml数据库都能够计算XQuery或XPath表达式并从索引直接处理查询,无需检索任何文档。
In many cases, a native XML database can evaluate an XQuery or XPath expression and resolve the query directly from the indexes, without ever having to retrieve a document.
这里还有一个查询重写思想:如果可能的话,删除谓词中的列表达式确保谓词是可索引的。
Here's one more query rewrite idea: if possible, remove column expressions in predicates to make the predicates indexable.
然后,数据被使用诸如XML模式表达式索引、B-树结构索引、结构索引、内容或关键字索引之类技术以及其他技术进行索引。
The data is then indexed using techniques such as XML pattern expression indexing, B-tree structural indexing, structural indexing, content or keyword indexing, and others.
从XML数据结构到搜索引擎的映射是使用XPath表达式来完成。
The mapping maps from the XML data structure using xpath expressions into the search engine.
这个表达式在花括号({})中使用,它定义了和的索引。
This expression is used inside the braces {} that define the index of the summation. The syntax for an expression is
另一个小型支持函数仅仅从(伪)xpath表达式中解析出索引值,这里就不再重复了。
Another small support function simply parses out index values if they are given within a (pseudo -) XPath. I will not bother reproducing that here.
当你想用单个子表达式索引捕获多个可选匹配之一的时候,可使用该结构。
This construct is useful when you want to capture one of a number of alternative matches in a single sub-expression index.
任意的一个整型表达式,都可以用来作为索引编号。
类型列指定路径表达式,则PATH辅助索引可以提高搜索的速度。
Type columns, a PATH secondary index may be able to speed up the search.
索引或表达式与集合的现有成员不匹配。
Index or expression does not match an existing member of the collection.
指定基于父表中的字段而又与子表中的索引相关的表达式。
Specifies the expression based on fields in the parent table that relates to an index in the child table.
方括号内的任意表达式(包括简单的标识符)都可以作为该属性的索引。
An arbitrary expression, including a simple identifier, inside square brackets can index the property.
强大的搜索引擎索引和适当的全功能的二进制搜索正则表达式引擎。
Powerful index search engine and a proper full-feature regular expression engine for binary searches.
强大的搜索引擎索引和适当的全功能的二进制搜索正则表达式引擎。
Powerful index search engine and a proper full-feature regular expression engine for binary searches.
应用推荐