Alex, For the basics of understanding Oracle explain plans, there are some pretty good resources on the web. A quick Google found the following, which on first glance provides a good start. http://www.akadia.com/services/ora_interpreting_explain_plan.html Once you get the basics under your belt, there are some experts on this list that can help answer your more specific questions. Dennis Williams