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
For more information on Oracle Cardinality, please check out the
Get the Complete
Oracle SQL Tuning Information
The landmark book
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
for 30% off directly from the publisher.