One method to use is to study the Execution Plans of the queries .Analyse the code - for example, is it forcing a table scan - where that may not be necessary.