Also, the response time of complex analytical queries can be reduced by spreading the data across multiple database partitions, such that all partitions work on their assigned data in parallel.
此外，通过跨多个数据库分区分散数据以使多个分区可并行处理分配到其上的数据，也能减少复杂的分析查询的响应时间。
This file is cumulative, in other words, if you have multiple SQL queries after SET EXPLAIN on statement, each query execution plan and its costs would be appended to this file until it is removed.
该文件是累积的，换言之，如果SETEXPLAINON语句之后有多个SQL查询，每个查询的执行计划及其成本都会被追加到文件中，直到将之删除。
Thus, the configuration of a replica database on which to run queries and extract reports should be a critical part of your database migration efforts.
因此，您执行查询和提取报告的复制数据库的配置是完成数据库迁移的关键部分。
This technique is similar to mapping, but produces a new ParallelArray on which further queries may be performed.
此技术与映射类似，但是形成新的ParallelArray，可以在其上执行进一步查询。
If there are no growing cost SQL queries in the snapshot, analyze the access plan to see which can be amended based on the accumulated data.
如果在快照中没有成本增加的SQL查询，可以分析访问计划，以查看可以根据累积的数据进行哪些修改。
Since the queries are dynamic, with unknown selection criteria at compile time, plan generation can be incorrect, even with the availability of full distribution statistics on the data.
由于查询是动态的，在编译时并不知道其选择标准，因此，即使有了关于数据的完整的分布统计，仍然可能生成错误的计划。
Such queries tend to be found in reporting applications that access significant amounts of data on one or more remote data sources.
这样的查询往往可以在一些报告应用程序中发现，这种应用程序访问一个或多个远程数据源上的大量数据。
It is especially suitable for embedded devices, for which large databases and sophisticated queries are not normally required, but it can also be used on larger devices.
它尤其适合嵌入式设备(这些设备一般不需要大型数据库和复杂的查询)，但是它也可以用在大型设备上。
Table functions are powerful because it can make any data source appear like a DB2 table, which can be then used in normal SQL queries, join operations, grouping, and so on.
表函数的功能很强大，因为它可以使任何数据源看起来类似于db2表，然后就可以用于常规的SQL查询、连接操作和分组等。
SQL queries can be constructed to retrieve OLAP data based on either the cube model or cube objects.
可以根据多维数据集模型或多维数据集对象构造SQL查询来获得OLAP数据。
On OLTP systems, where user sessions are performing quick queries, tuning this parameter can be very important.
在OLTP系统上，用户会话执行快速查询，调节此参数可能非常重要。
The choice of clustering columns needs to be based on the expected query workload so the clustering supports the most common and most critical queries.
集群列的选择需要基于预期的查询工作负载以便集群能够支持最常见和最关键的查询。
Flu Trends can never be used to identify individual users because we rely on anonymised, aggregated counts of how often certain search queries occur each week.
流感趋势项目绝不用来透漏个人使用者的身份，因为我们依靠匿名的汇总的计数来知道一定的查询内容在每个星期发生的频率。
The instructions can also be applied to queries based on the cube and cube-related objects.
这些说明也可以应用于基于多维数据集和多维数据集相关对象的查询。
Doing so can be useful if you need to write queries that filter data based on XML and non-XML column values.
如果需要编写根据XML和非xml列的值过滤数据的查询，那么这样做很有用。
Prepared statements can be significantly faster than regular queries depending on the database being used.
准备语句相比普通查询来说要快很多，当然跟使用的数据库有关系。
If the master query table has a large volume of data, perhaps millions of rows, then there might be an unacceptable amount of queries issued to the database table on the detail side.
如果主查询表拥有大量数据，比如数百万行，那么向明细端上的数据库表发出的查询量可能难以接受。
They may take a long time to arrive (see the discussion above on feedback); in fact, the queries might never be answered.
可能花很长时间才能到达(参见反馈中的讨论)，事实上请求可能根本没有回答。
On the other hand, if queries are ad-hoc, it is unlikely that indexes will be available.
另一方面，如果查询是特别的，则不大可能有索引可用。
To speed searches, you may be able to rearrange your tables and, thus, simplify the underlying queries. table and SQL query optimization are highly dependent on your schema and engine.
要加速搜索，您可以重新安排表，并由此简化底层查询表和SQL查询优化高度依赖于模式和引擎。
Demonstrates operations and queries that can be performed on remote data.
演示可以对远程数据执行的操作和查询。
XQuery has the advantage that it is designed for producing XML or HTML documents as the result of its queries, so no postprocessing would be required on query results.
XQuery的优点是，它是为生成XML或者HTML文档作为查询结果而设计的，因此不需要对查询结果进行后处理。
I'll focus on Solr's function queries because they are the easiest to use and require no programming to leverage, but they can easily be used in or ported to Lucene.
我将关注Solr的函数查询，因为它们是最容易使用的并且不需要编程。可以在Lucene中轻松地使用它们，或者轻松地将它们移植到Lucene。
Both the queries made to Registry and Repository and their results can be held internally in a cache on an execution group level.
对Registry andRepository发出的查询及其结果都可以在执行组级别内部地保存在缓存中。
RDQL queries can be executed on the command line against a jena model using the jena.rdfquery tool.
使用jena. rdfquery工具可以在命令行上对jena模型执行rdql查询。
The add-in can be used to build map graphics against queries on SQL Server 2008 spatial data.
该插件可和MapPoint一块用于查询SQLServer 2008空间数据以建立图解地图。
By building on this capability, Mathematica users may soon be able to write and their code using natural language queries just like in Wolfram Alpha.
基于这个功能，Mathematica用户也许很快可以通过类似于在WolframAlpha中使用的自然语言查询来编写和操作他们的代码。
Thousands of developers respond to queries on the Struts mailing lists, and tens of thousands have tried out Struts and reported problems, thus allowing them to be easily fixed.
数千名开发人员对Struts邮件列表上的问题作出答复，数万名开发人员试用Struts并报告问题，这使得这些问题很容易得到修复。
Thousands of developers respond to queries on the Struts mailing lists, and tens of thousands have tried out Struts and reported problems, thus allowing them to be easily fixed.
数千名开发人员对Struts邮件列表上的问题作出答复，数万名开发人员试用Struts并报告问题，这使得这些问题很容易得到修复。
应用推荐