SQL Tuning [Electronic resources] نسخه متنی

B.6 Altering the Application

As is most commonly the case, the
only change the application needs, in this example, is the slight
change to the SQL itself. This is always the most favorable result,
since such SQL-only changes have the lowest risk and are the easiest
to make. This query will return just a few rows, since the best
filter, alone, is so selective. If the query returned excessively
many rows, or if the query ran excessively often just to perform a
single application task, you would explore changes to the application
to narrow the query or to run it less often.