Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to improve the performance if sql query has order by clause?

user-image
Question added by suresh babu manukonda , Database Lead , creditsafe
Date Posted: 2016/03/25
Nayyar Jawaid Ali Khan
by Nayyar Jawaid Ali Khan , Manager Business Applications , Techsource LLC

After adding indexes use table index hints to boost query performance if your database allows...

Good luck!

 

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

Having Indexes on the tables will help performance overall for sure. Thanks.

More Questions Like This