The initial idea was to develop custom code that would query the Browse database directly for a random author name.
最初的想法是开发能够由随机作者名称直接查询浏览数据库的定制代码。
In order to run this report in Dynamic Query Mode, the report author should determine whether the summary filter is still required or not.
为了以DynamicQueryMode执行这个报告，报告作者应该确定是否仍然需要摘要过滤器。
Since this query contains no value predicate to restrict either the books or the authors table, DB2 has to perform a table scan on either of the two tables to read all author IDs.
由于该查询没有包含用来限制books或authors表的值谓词，因此DB 2必须在两个表上执行表扫描，以便读取所有author ID。
If you know that all author IDs are Numbers, you can indicate this in your query to allow DB2 to use the DOUBLE indexes.
如果您知道所有authorID都是数字，则可以在查询中指明，从而允许DB 2使用DOUBLE索引。
If you know that all author IDs are Numbers, you can indicate this in your query to allow DB2 to use the DOUBLE indexes.
如果您知道所有authorID都是数字，则可以在查询中指明，从而允许DB 2使用DOUBLE索引。
应用推荐