Performance of Query

[Ralph]

What are the SQL tuning hints one can apply if the SQL query runs too long time? I have good indexing done on the table. I want to further improve the performance of the query which is planned to run for long hours. Kindly provide me some ways for achieving the best performance of my query.

[Rahulbatra]

One important guideline I could give you is Check whether you have placed index on all fields which you use for joining. If not first do that since this will help you to fetch and store values in an efficient way.

[rachelle]

In the select statement always place whatever columns which you need in your output for other queries. Avoid selecting unnecessary attributes in select columns. This methodology would help in increasing your performance in a sufficient manner.