Bayt.com

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?

Oracle
user-image
Question added by suresh babu manukonda , Database Lead , creditsafe
Date Posted: 2016/03/25
Upvote (1) Views (3) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
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.

Write Your Answer
More Questions Like This