Baseline Tuning

A functional query is not necessarily a fast query. You run your first baseline once you have formulated a functional query: a query that returns the expected result. You run your baseline against representative data volumes on a mostly quiet system. Your baseline is the fastest you can ever expect your query to run. Higher system loading will only slow your query down. In any case, your first baseline may be your first indication that you have a problem. Specifically, your baseline fails to meet performance expectations. So your first baseline collection may evolve into a tuning effort.