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根据您的需要过滤和处理数据,而不是在应用程序中做这项工作。
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.
本文已经开发了一些普通的数据库功能,例如:更新一个数据库、显示查询结果、连接两个数据表、以及使用不同的过滤条件筛选结果等。
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子句求值。
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所示:我们准备定义一个只允许相关信息的过滤器。
You must build an index for every multiline text field in the user database where a text query is used as a filter.
您必须在用户数据库中为每一个多行文本域建立一个索引,在这个数据库中文本查询相当域一个筛选程序。
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.
在满足筛选器条件的每个行中,数据库服务器将对键应用哈希函数,并探测哈希表以查找匹配的键值。
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.
它提供很大的灵活性,可以在数据库级检查数据格式,也可以在表级进行检查。
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可以利用通常的数据库技术,即索引访问。
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.
星型连接计划中,数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
Let you filter out database objects in the database Explorer so you see only the objects that you are interested in.
允许过滤数据库浏览器中的数据库对象,这样就能够只查看感兴趣的对象。
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)。
Next, Jane wants to filter some data so she can view the database on sales rep, revenue, or location of the customer.
接下来,Jane想过滤一些数据,以便查看销售代表、收入或客户位置等数据。
In this paper, we use some database technology, such as related searches, participle, and statistics to extract and filter the data.
本文利用数据库关联搜索、分词、统计等技术,对数据进行提取和过滤;
In this paper, we use some database technology, such as related searches, participle, and statistics to extract and filter the data.
本文利用数据库关联搜索、分词、统计等技术,对数据进行提取和过滤;
应用推荐