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!
4 comments:
LOL--glad to see things going better. I miss you, Babe. I can't wait to see you again. ;-)
Now that's what I call improvement! It's almost at warp speed!
Oops! Forgot to say it was me (Fernando) writing above.
I found you!!! I was planning to stop by your house yesterday (the saturday bf Father's Day) but I was caught short in time (you guys went to see your dady)
Anyway, I just wanna wish you a Great Father's Day! I hope everything ran smooth in your big day:)
Post a Comment