Optimizer mechanism to choose best plan
Experts,
As i know Optimizer chooses best plan based on time & cost (time – response time, cost – cpu resource utilization) and then current statistics about data volume , indexes, and joins.
Any other things are considered in background !
Regards,
Thiyagu G