How To Use Optimizer Hints To Specify Cardinality For Join Operation
(Doc ID 2402821.1)
Last updated on MARCH 18, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
Goal of the document is to show how an optimizer hint can be used in a SQL statement to specify the cardinality (no.of rows) for a join operation.
Generally, CARDINALITY hint is used to specify the no.of rows for a table and not for join.
Generally, CARDINALITY hint is used to specify the no.of rows for a table and not for join.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |