SQL Query Tuning Considerations

While tuning SQL query what should be taken into consideration?

Questions by ramesh.akula9

Showing Answers 1 - 3 of 3 Answers

edarasatish

  • Jun 23rd, 2009
 

During the SQL tuning, there couple of things need to be considered

1. If it is below Oracle 9i we need make sure about the driving table concept (Since it uses RBO - Rule Based Optimization), which improves the performance, After
Oracle 9i Oracle will automatically

2. Make sure it is using proper indexes


3. We can escape some indexes (Ex: if there is a table called X is having 3 indexes, in that one is primary index and the two are normal indexes. In your if it is using the three indexes, we can escape the two normal indexes since primary index improves the performance).


4. Do an explain, so that we can identify any full table scans. Escape the full table scans.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions