Db : 10g and above.
I read below link which says that " Cost-Based Optimizer (CBO) - The CBO uses database statistics to *generate several execution* plans, picking the one with the lowest cost, where cost relates to system resources required to complete the operation."
Is it possible to see all the execution plan for a particular query?
My intention is to know why CBO rejects other plans.
Thanks & Regards,