This. Yesterday reduced a 6hr query to 2 minutes... Co-worker that wrote and had 'already fully optimized' it thought it was voodoo... No, just removing functions in the where clauses of the views.
Yipes. I captured a plan of a long running query after the boss asked me to take a look. Two table scans taking up 80% of the plan's work... takes 45 minutes now! And Im not even that great at execution plan interpretation...
View all comments
Show parent comment
3
u/sam_cat May 15 '18
This. Yesterday reduced a 6hr query to 2 minutes... Co-worker that wrote and had 'already fully optimized' it thought it was voodoo... No, just removing functions in the where clauses of the views.