I have following question related to oracle optimizer.
When a query is given to optimizer,
1. How it creates different plans without executing it.?
2. I believe only if the results are less than certain % of rows it uses index, for identifying this,
it has to execute query right?
Please help me in understanding the above by giving some relevant examples or links.