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.
