News
Abstract
The new SELECTIVITY clause can be optionally used to tell SQL Query Engine (SQE) how selective a predicate will be for a query.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > SELECTIVITY clause on queries
Best practice: Use this new, optional SQE hint sparingly.
SQE includes cost-based optimization and a Global Statistics Manager, which typically results in a query plan and implementation that is optimal and not in need of hinting.
Refer to the Performance and Query Optimization section for usage details: Use SELECTIVITY to supply missing information
See the SQL Reference for syntax details: Search conditions
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]
Was this topic helpful?
Document Information
Modified date:
06 October 2020
UID
ibm16340679