Hi A difficulty I often face when asked about the tuning process... We know that one of the first steps is to see the current query execution process using EXPLAIN PLAN. But I find myself stumped in explaining anything beyond the point of determining the Indexes and Join methods used. As I don't have much DBA experience, I find it difficult to clearly explain the actual steps you would take to 'tune' the code after gathering data from the plan table. Can anyone help me with the set of steps to follow using the plan output? I agree that it is largely situation-based, but I'm looking for a general algorithm which would help me approach a query performance issue. Thanks!