This is my presentation on how Oracle Optimizer comes up a cost of accessing any table or any index.
I have also shown how the cost of any join in computed. I hope this will provide enough information for you to understand the concept and apply it to your problems.
Oracle Costing Algorithm
If you have any questions, feel free to leave a comment.
