Question: What does Oracle carnality
mean? I'm told that I must tune my SQL with Oracle cardinality, and
I am unfamiliar with the term cardinality and SQL?
Answer: The Oracle term cardinality
refers to the number of rows returned by a distinct SQL optimization
step, and the term
cardinality feedback refers to looking at the estimated
cardinality of each SQL optimization step and tuning for the most
efficient
table
join order.
For more information on Oracle Cardinality, please check out the
following:
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
