The last section discussed how to apply filter predicates at the database level to improve query performance and response times.
最后一节讨论如何在数据库级应用过滤谓词,以提高查询性能和缩短响应时间。
Avoid duplicating the work of a database server: Instruct DB2 to filter and process data according to your needs rather than doing this work in your application.
避免重复数据库服务器的工作:指示DB 2根据您的需要过滤和处理数据,而不是在应用程序中做这项工作。
A more efficient technique is to filter database rows by placing conditions in the WHERE clause, which is evaluated immediately after the tables are specified within the FROM clause.
更有效的方法是通过在where子句中放置条件来过滤数据库行,在from子句中指定表之后会立即对where子句求值。
Now that the view injects the filter predicate at the SQL level, DB2 can take advantage of the usual database techniques, that is index access.
现在,该视图在sql级注入过滤谓词,DB 2可以利用通常的数据库技术,即索引访问。
For each row that satisfies the filter condition, the database server applies hash function to the key and proves the hash table to find a match.
在满足筛选器条件的每个行中,数据库服务器将对键应用哈希函数,并探测哈希表以查找匹配的键值。
In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.
星型连接计划中,数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
This article has explored some common database functions such as updating a database, displaying query results, joining two tables together, and filtering the results using various filter conditions.
本文已经开发了一些普通的数据库功能,例如:更新一个数据库、显示查询结果、连接两个数据表、以及使用不同的过滤条件筛选结果等。
You have the flexibility to check the data format on database level as well as to narrow down the filter on the table level also.
它提供很大的灵活性,可以在数据库级检查数据格式,也可以在表级进行检查。
Rational data Architect allows filtering at any level of the data structure in the Database Explorer, shown in Figure 1. We will define a filter that will leave only relevant information.
RationalDataArchitect允许在DatabaseExplorer的任何数据结构层级进行过滤操作,如图1所示:我们准备定义一个只允许相关信息的过滤器。
Each database will be queried for a potentially significant amount of data and then joined locally to filter out unwanted records.
每个数据库都将被查询并可能生成大量数据,然后以本地方式联接以过滤不想要的记录。
You must build an index for every multiline text field in the user database where a text query is used as a filter.
您必须在用户数据库中为每一个多行文本域建立一个索引,在这个数据库中文本查询相当域一个筛选程序。
Let you filter out database objects in the database Explorer so you see only the objects that you are interested in.
允许过滤数据库浏览器中的数据库对象,这样就能够只查看感兴趣的对象。
Next, Jane wants to filter some data so she can view the database on sales rep, revenue, or location of the customer.
接下来,Jane想过滤一些数据,以便查看销售代表、收入或客户位置等数据。
After the filter is loaded, all Soap message requests for Web services on your server create new log documents in the SoapLog.nsf database (see figures 12 and 13).
装入过滤器后,服务器上Web服务的所有Soap消息请求将在SoapLog. nsf数据库中创建新的日志文档(参见图12和13)。
Data Studio Administrator provides an array of views that enable you to sort and filter your database objects.
DataStudioAdministrator提供一系列视图,可以用它们排序和筛选数据库对象。
In this paper, we use some database technology, such as related searches, participle, and statistics to extract and filter the data.
本文利用数据库关联搜索、分词、统计等技术,对数据进行提取和过滤;
This paper proposes not only index of multilevel fingerprint database that is built by fingerprint pattern, ridge count and FingerCode based on Gabor filter but also a search method of it.
文章提出使用指纹纹形、脊线数目和基于Gabor滤波的指纹特征———指纹码构建多级索引指纹数据库和在此基础上检索多级指纹数据库的方法。
This paper proposes not only index of multilevel fingerprint database that is built by fingerprint pattern, ridge count and FingerCode based on Gabor filter but also a search method of it.
文章提出使用指纹纹形、脊线数目和基于Gabor滤波的指纹特征———指纹码构建多级索引指纹数据库和在此基础上检索多级指纹数据库的方法。
应用推荐