For example, you can minimize the rows read by having predicates in the query that can determine the needed rows from just the index alone.
例如,您可以通过把可以仅从索引就确定需要的行的谓词放到查询中来将行读取降到最低。
This means that each query is built by dynamically merging the input from the user (which is generally duly sanitized) and then executed as a query of its own.
这意味着,每个查询通过动态合并来自用户的输入(通常经过适当的检查)构建,然后作为查询本身执行。
Attributes from the slice of the cube model accessed by the query.
来自查询访问的多维数据集模型切片的属性。
You can build an XML query visually by selecting sample resultant nodes from a tree representation of a schema or XML document and dragging the nodes onto a return grid.
您可以通过从一个模式或XML文档的树型表示中选择示例结果节点,并将这些节点拖放到一个返回网格中,从而可视化地构造一个 XML查询。
To search image by content, you must first import an image, or draw a sketch, that you can use to query and present images from a collection.
要按内容进行搜索,必须首先导入一个图像或绘制一个草图,然后用它来从一个集合中查询或呈现图像。
To properly assess these access path alternatives, you'll need information from the DB2 catalog about the tables accessed by the query and the indexes defined on those tables.
为了正确地评估这些访问路径,需要从DB 2编目中获取关于查询访问的表以及这些表上定义的索引的信息。
The customer ID is also extracted from the message and is used to query the database for information on the items purchased by the customer.
再次从消息中提取出客户ID,并用它在数据库中查询这位客户购买的商品的相关信息。
By the way, I'm saying "files" here, but the data source could really be anything - chunks of a very large file, rows returned from an SQL query, individual email messages from a mailbox file.
顺便说一下,我在这说“文件”,但数据源可以是任何东西——一个非常大的文件块,一个SQL查询返回的元组,一个邮箱文件中的单个邮件信息。
These will be the only two attributes returned from the database by this query.
该查询只从数据库中返回这两个属性。
If you run the final query from Listing 6, as it is shown above, you should see in the access plan that DB2 decides to use the extended index by the EISCAN operator.
如果运行清单6中最后的查询(如上面所示),这么在访问计划中应该可以看到,DB 2决定通过EISCAN操作符使用扩展的索引。
There will be one or more attributes from the facts object referenced by the join object, which is used to join the dimensions of the query to the facts object.
用来将查询的维联结到事实对象的联结对象会引用事实对象的一个或多个属性。
After running the query, search results will return, and they can be exported by right clicking and selecting "export" from the drop down menu.
在运行查询之后,会返回搜索结果,通过右击并从下拉菜单中选择“Export”可以将这些搜索结果导出。
In this article I provided generic mappings from the Oracle style CONNECT BY recursive query syntax to DB2's standard compliant recursive common table expressions using UNION ALL.
在本文中,我提供了从oracle型CONNECT BY递归查询语法到DB 2中遵从标准的使用UNION ALL的递归公共表表达式的通用映射。
By permitting you to query third-party services using commonly understood SQL syntax, YQL saves you time and effort and makes it easier to integrate data from disparate sources into a web application.
通过允许您使用通常理解的sql语法查询第三方服务,YQL可以节省您的时间和精力,并且更易于将来自不同来源的数据集成到一个Web应用程序中。
Furthermore, a novel concept called "semantic synonyms" radically simplifies searching for concepts extracted from unstructured text by transforming the user's keyword query.
另外,还有一个称为“语义同义词(semantic synonym)”的新概念,它通过转换用户的关键字查询,从根本上简化对从非结构化文本中提取的概念的搜索。
The first JSP, Welcome.jsp, occupies both the presentation layer and the data layer by using the JSTL SQL library to issue an SQL query from the page.
第一个JSP,即Welcome.jsp,使用JSTLSQL库从该页面发出一个 SQL查询,因而同时占据了表示层和数据层。
By analyzing the Visual Explain output in Figure 6, from the second query, it is possible to confirm that the optimizer ran with the expected optimization goal of FIRSTIO.
通过分析图6中对于第二个查询的VisualExplain输出,可以证实优化器将达到FIRSTIO的预期优化目标。
FetchPlan's rich syntax and semantics allow the application to configure the closure for any root instance resulting from a find operation or instances selected by query.
FetchPlan的丰富语法和语义允许应用程序为find操作结果的任何根实例或查询得到的实例配置闭包。
Optim query Tuner provides a series of advisors to automate the query tuning by giving recommendations, which you can review and implement directly from the product to resolve a performance issue.
OptimQueryTuner提供了一系列建议工具,通过提供建议来自动化查询调优,从而您可以直接在本产品中评审和执行,从而解决性能问题。
Limited data in Query Studio is made possible by metadata modellers implementing Design filters, which limits the rows retrieved from the data source based on the filters.
QueryStudio中的限制数据是由元数据建模器实现的DesignFilters产生的,它限制了基于过滤从数据源检索出的行数。
Yellow Pages or a service pool to query often-changing and more complex information (e.g. a route from Berlin to Porto by car, or the current temperature of Porto in Celsius).
黄页服务或者一个服务池(servicepool)。用来查询不断变化和日益复杂的的信息(比如开车从柏林到波尔图的路线,以及波尔图当前的温度)。
Whenever you try to query a spatial column, DB2 injects a transformation from the internal, structured type representation to a representation that can be understood by the application.
每当尝试查询一个空间列时,DB 2加入一个转换,该转换将内部的、结构化类型的表示转换为应用程序能理解的表示。
So at least 653 pages would need to be read from disk if the rows were distributed in such an ideal way that only rows accessed by the query are to be found on the loaded pages.
所以,如果这些行以理想的方式分布,要使得只有被查询访问的行可以在装载的页上找到,那么至少需要从磁盘读653个页。
These are automatically set by the server to the values from the form elements of the same name, which become HTTP POST query arguments.
这些参数是由服务器根据同名表单元素中的值自动设置的,它们变成了HTTPPOST查询参数。
Creating a view of the XML data helps to abstract the structure of the product XML from the application code, by allowing us to simply query the view.
创建XML数据视图使我们可以轻松地查询视图,从而有助于从应用程序代码理解产品XML的结构。
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.
类型化数据集设计器允许你添加自己的查询语句,通过在适当表格的上下文菜单中选择“添加”|“查询”来实现。
For example, you can easily search for the applications consuming the highest amount of CPU by simply adding a WHERE clause to a query that lists application data from a monitoring table function.
例如,只需在列出监控表函数返回的应用程序数据的查询中添加where子句,就可以搜索CPU消耗量最大的应用程序。
Optim makes application retirement easier and safer by providing the capability to archive data from decommissioned applications while providing ongoing access to the data for query and reporting.
Optim能够归档退役应用程序的数据,同时能够根据查询和报告需要继续访问数据,因此轻松实现了应用程序退役。
This pattern can improve query performance by allowing applications to more quickly retrieve data from a data store.
这种模式可以提高查询性能,让应用程序更快速地从存储中检索数据。
This pattern can improve query performance by allowing applications to more quickly retrieve data from a data store.
这种模式可以提高查询性能,让应用程序更快速地从存储中检索数据。
应用推荐