因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义，所以不会影响查询性能。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
如果语句涉及到更大的表格和两个或者更多个表的连接的话，查询访问计划就很可能会因为基数估计值的提高而改变。
Statements involving larger tables and joins of two or more tables are more likely to exhibit a change in query access plan as a result of the improved cardinality estimate.
因此，如果查询筛选字段是这种类型中的一个，而相关的表格很大，那么查询的速度会非常慢。
Therefore, if a query filter field is one of these types, and the associated table is large, the query can be very slow.
所以你可以查看所有的内容或任何表格，可以在页面用到的每个数据库里执行任意的查询。
So far you can view the full contents of any table and run arbitrary queries on each database a page is using.
这跟在SQL查询中加入表格很相似，方法就是选择其数据应为查询结果一部分的表格。
It's almost like joining tables in an SQL query, by selecting tables whose data should be part of the results of the query.
执行SQL查询并从查询结果集的每个字段中创建电子表格单元格，实现这些操作很简单。
It's quite easy to execute an SQL query and then create spreadsheet cells from each field of the query result set.
要实现伪事实查询主题，就要在数据库中创建一个一行的表格，或者使用虚拟表，例如SYSDUMMY1在DB 2中使用SYSDUMMY1，或者在Oracle中使用Dual。
To implement a fake fact query subject, either create a one row table in the database or use a virtual table such as SYSDUMMY1 for DB2 or Dual for Oracle.
请将Application Developer生成的代码作为示例，了解如何将规则的查询转换为数据库可以理解的表格。
Refer to the code generated by Application Developer for examples of how to translate a rule’s query to a form understandable by a database.
它还提供了一个搜索表格，因此如果我知道自己想找什么但不知道网址，我就可以提交一项查询来找到它(假设鬼把戏不起作用……)。
It also provides a search form, so if I know what I'm looking for but not the URL, I can submit a query to track it down. (Assuming the Jedi mind trick doesn't work...)
使用pureXML，您可以有效地存储、控制、查询、更新XML数据以及存储在同一个表格和数据库中的关系数据。
With pureXML, you can efficiently store, control, query, and update XML data alongside relational data stored in the same table or database.
通过这种方式，BIRT中的数据集就像RationalTeam Concert返回至查询的信息一样：一个作为储存库中信息子集的数据的表格。
In this way, a data set in BIRT is just like the information that Rational Team Concert returns from a query: a table of data that is a subset of the information in the repository.
单击addTable向查询添加一个源表格。
Wilson提供足够的SQL来帮助您学习如何在关系数据库中通知数据，并且他还涵盖了表格、连接、求反和嵌套查询。
Wilson provides enough SQL to help you learn how to massage data in a relational database, and he also covers tables, joins, negation, and nested queries.
如果表格有一定数量的片段键(或者分区键)值，而且在片段键上有同等谓词的表格上查询时，它会很有用处。
It is useful when a table has a finite set of values for the fragment key (or partitioning key) and queries on the table have an equality predicate on the fragment key.
本文给出了所有此类任务的例子，以及两个示例应用程序：面向RSS提要和数据库查询结果的电子表格导入器。
This article provided examples of all of these tasks, together with two example applications: spreadsheet importers for RSS feeds and database query results.
如果您不再想在这个表格的任何一个域上激活不能区分大小写查询程序，您可以使整个表格的索引功能失效。
If you no longer want to enable case-insensitive queries on any field in the table, you can disable indexes for the entire table.
最后，本文将向您展示如何对存储在DB 2中的XML表格数据进行查询。
Finally, the article shows you how to query against the XML form data that gets stored in DB2.
使用这个特性，可以浏览应用程序访问的数据库、找到表格和字段名并返回查询结果。
With this feature, you can browse the database your application talks to, find out the table and field names, and run queries.
不像工作项查询，报表可以显示一般结构的表格、图表、形式、标签以及图片。
Unlike work item queries, reports can show custom-structured tables, charts, styles, labels, and images.
数据建模：包装器负责将远程查询结果的数据表示映射为联邦引擎所要求的表格式。
Data modeling: a wrapper is responsible for mapping the data representation of remote query results into the table format as required by the federated engine.
为这个程序定义一个新的问题查询，确保能够具体指定表格1中所列出的值。
Define a new query for this bean, being sure to specify the values listed Table 1.
当您在大型审核日志表格中运行查询功能时，您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
类型化数据集设计器允许你添加自己的查询语句，通过在适当表格的上下文菜单中选择“添加”|“查询”来实现。
The typed DataSet designer accommodates by allowing you to add your own queries from the appropriate table's context menu by selecting add | Query from the table's context menu.
这种控制通过ORDER BY 子句以及表合格列名称在查询列表格中出现的顺序实现。
This control is provided in the form of the ORDER BY clause in conjunction with the order in which table qualified column names appear in the query elements table.
检索到数据以后，将以包含查询结果的xml列表格式提供数据，如下所示。
After the data has been retrieved, it is supplied in an XML list format that contains the results of the query, as shown below.
这样您就可以简单地从您的测试脚本中调用必要的方法(例如在一个表格中查询)。
This allows you to simply call the necessary method (for example to query on a table) from your test scripts.
以下查询从提交的所有表格中查询用户ID并将它们以varchar形式返回。
The following query finds the userid from all submitted forms and returns them as varchar.
以下查询从提交的所有表格中查询用户ID并将它们以varchar形式返回。
The following query finds the userid from all submitted forms and returns them as varchar.
应用推荐