I am trying to learn SQL query optimization using SQL Server 2005. However, I did not find any practical example where I can improve performance by tweaking query alone. Can you please list some example queries – prior and after optimization?
It has to be query tuning – not adding index, not making covering index, not making any alteration to table. No change is supposed to be done on table and index. [ I understand that indexes are important. This is only for learning purpose]
It would be great if you can exaplain using temp table instead of refering any sample databases like adventureworks.
Expecting your support…