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子句求值。
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根据您的需要过滤和处理数据,而不是在应用程序中做这项工作。
应用推荐