I have few heavily accessed tables with less than 1 million rows in each of them that are really taken a long time to return data. Could someone give me guidelines on how to improve performance on those tables?
I sincerely appreciate your assistance.

KC
Data Analyst