Disagree. For example, indexes are an optimization mechanism which tune the SQL engine for your data set and queries. Creating and planning indexes are outsid

Disagree. For example, indexes are an optimization mechanism which tune the SQL engine for your data set and queries. Creating and planning indexes are outside the scope of your SELECT query, but can give a dramatic performance difference, with the exact same SQL query. See also triggers.