Over the next 8 weeks, I hope to discuss the ever confusing world of indexes. I know this topic has been written about and covered in depth by smarter people than me, but this is my attempt at trying to discuss a topic that is as elusive as quantum mechanics. But more importantly, I am also using this exercise as a learning tool for me. As an accidental DBA turned “official” DBA, I want to learn as much as I can about a very powerful tool that helps SQL run efficiently.
Why 8 weeks? I m being realistic, I am new to blogging and especially new to technical blogging so I am trying to pace myself so I actually present correct information. Here is my outline:
- Introduction (this post)
- What is an index?
- Types of indexes
- Structure of an index
- Determining what indexes your tables have now
- Are they effective indexes? What makes effective indexes?
- Management of indexes? They are not “set it and forget it”!
- What I’ve learned