8 Week of Indexes: Introduction

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:

  1. Introduction (this post)
  2. What is an index?
  3. Types of indexes
  4. Structure of an index
  5. Determining what indexes your tables have now
  6. Are they effective indexes?  What makes effective indexes?
  7. Management of indexes?  They are not “set it and forget it”!
  8. What I’ve learned

3 thoughts on “8 Week of Indexes: Introduction

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s