It's useful for queries that don't read from any tables or views.
这对于不从任何表或视图进行读取的查询是有意义的。
Use policies to define authorization for queries and disclosure of data.
使用策略为数据的查询和公开定义授权。
This is perfectly fine for queries up to a certain degree of complexity.
对于有一定复杂度的查询，这样非常好。
For queries 2 through 5, file system caching does not play a significant role.
对于查询2到查询5，文件系统缓存的影响不大。
The DNS server will not perform recursion for queries to other DNS servers.
DNS服务器将不执行向其他DNS服务器的查询递归。
Dimensional modeling helps us optimize our warehouse data for queries and analysis.
维度建模有助于优化数据仓库的查询与分析。
For queries that do not match any guideline, the regular cost-based access plan is chosen.
对于不与任何准则匹配的查询，将选择常规的基于成本的访问计划。
Run an SQL script to build the indexes for all multiline text fields that will be used for queries.
运行一个sql脚本来为所有将要被查询的多行文本域建立索引。
CMP EJB query doesn't perform well in a query scenario, and that is why we used direct JDBC calls for queries.
CMPEJB查询在查询场景中不能执行，这正是我们为查询使用直接JDBC调用的原因。
Closed test cases will only appear in the results list for queries that do not exclude closed test cases.
已关闭的测试用例仅出现在不排除已关闭测试用例的查询的结果列表中。
Too many columns in a table can make the scan time for queries much longer than if there are just a few columns.
一个表中有太多列比仅有一些列时进行查询所需的扫描时间要长。
Areas represent key components of a team project, and you use them to group work items for queries and reports.
区域表示团队项目的主要组件，用于针对查询和报表对工作项进行分组。
You use work item fields to track data for a work item type, to define the criteria for queries, and to design reports.
可以使用工作项字段跟踪工作项类型的数据、定义查询的条件以及设计报表。
Language-integrated query (LINQ) support provides compile-time syntax validation for queries against a conceptual model.
语言集成查询 （LINQ）支持可为针对概念模型的查询提供编译时语法验证。
For queries that return a set of user IDs, a union of the results of all queries is created, and builds the result set of user IDs.
对于返回一组用户ID的查询，将创建所有查询结果的并集，并构建用户ID的结果集。
For queries of low or medium complexity, including the ones in the query MIML Data in DB2 section, the query performance is good.
对于复杂度较低或中等的查询，包括查询DB 2中的MIML数据小节中的查询，查询性能很好。
For queries that touch only a small to medium number of rows, the performance difference between the two test databases was negligible.
对于只涉及少量到中等数量的行的查询，两个测试数据库之间的性能差异可以忽略不计。
For queries that match the active profile, the optimizer makes the best possible effort to generate the plan requested by the guideline.
对于匹配当前概要文件的查询，优化器将尽最大的努力来生成准则所要求的计划。
The benefit is greatest for queries that contain remote operations that require significant processing before they begin to return rows.
如果查询中的远程操作在返回行之前需要进行大量的处理，那么就可以获得最大的性能益处。
Data disclosure control for queries against the repository, for example, the simple event queries according to EPCglobal's EPCIS standard.
对存储库的查询进行数据公开控制，例如根据EPCglobal的EPCIS标准控制简单事件查询。
To get reasonable response times for queries on large tables, it is a best practice to define indexes for certain columns or combination of columns.
为了获取在大容量表中查询的合理的响应时间，最好为某列或者列组合定义索引。
Allowing too much free space, however, could cause extra pages to be read for queries and largely defeat the purpose of using a clustering index.
不过，如果允许太多自由空间的存在，则可能导致查询时需要读取额外的页，这反而大大违反了使用群集索引的本意。
Changing the default value does not affect the query formulation if the data type is the same, but it affects the results for queries on those values.
如果数据类型相同，改变默认值对查询公式没有影响，但是影响这些值的查询结果。
Over time, the language has been added to so that it is not just a language for queries, but can also build databases and manage the database engine's security.
随着时间的推移，该语言增加了许多功能，因而它不仅仅是一个查询语言，还可以创建数据库，控制数据库引擎安全。
Data is loaded through standard extract, transform, and load (ETL) connectors, and is then available for queries from business intelligence and analytics applications.
数据通过标准的提取、转换和加载(etl)连接器加载，然后可供商业智能和分析应用程序进行查询。
We found a bigger difference for queries that touch a large number of rows, such as a table scan over all 20,000 XML documents with string comparison on every document.
我们发现涉及大量行的查询的性能差异比较大，比如对所有20,000个XML文档进行全表扫描并对每个文档比较字符串。
Another benefit of the move to DB2 9 is the hybrid storage engine and a query optimizer that "understands" XML (mapping to relational algebra for queries involving XML).
迁移到DB 29的另一个好处是，混合型存储引擎和查询优化器“理解”XML，可以把涉及XML的查询映射为关系语法。
Because query results from the [HistoricSales] cube are pre-cached, the performance for queries that are run against the sales data of the entire time period is improved.
因为预先缓存了来自[HistoricSales]数据集的查询结果，所以整个时间段的销售数据执行的查询性能得到了改善。
The title and the URL of the page will still be visible, and the page may also continue to rank in search results for queries related to content that has been removed.
标题和该页网址仍讲可见，该页页可以继续排在请求与已删除内容相关内容的搜索结果中。
Try out the examples in this article to experience how you can improve runtime performance for queries that contain host variables or parameter markers by using the REOPT option.
通过尝试本文所给出的示例，您就能够体验到如何使用REOPT选项来提高那些包含主机变量或参数标记的查询的运行时性能。
应用推荐