The whys and hows of sql indexing are going to be an interesting topic for another day’s post, but it is sufficient background to know that I deal with indexes daily, and it’s one of the pivots of my job as a dba… It’s almost like being a mechanic and not having any power tools. How much do you think you’ll accomplish in a day without your power tools?
Well, I’ve been working on this report for a couple of days, and one of my biggest obstacles has been performance. Each time I hit “run”, it takes about 15 mins for the report to complete. If I made a mistake, then it’s another 5 mins to fix the mistake and then another 15 mins of waiting!!!!
After a bit of enlightenment this morning, I did some tuning and indexed the heck out of the database tables I’m using. After about 1 hour worth’s, the report now completes in :03 secs. This is 30000% more efficient! Thank you indexes!
