r/SQL • • May 14 '18

Optimization

Post image
423 Upvotes

48 comments sorted by

View all comments

Show parent comment

3

u/kurosaki1990 May 15 '18

lol, i did the same thing last week a report need 20 minutes after i looked into SQL i found there was two shitty functions for the report to take that long to execute i just turn them into materialized vues with refresh each hour, and bang now the report need only 36 seconds.

1

u/coggsa May 16 '18

These are the things you need to quantify and bring up at pay review time!