How do you name your indexes?

There are many posts and articles on naming conventions, I’d like to throw my own out there.  First off I always create a spreadsheet that is used to log index name, server, database, table, reason for creation, estimated performance increase (you get this from estimated execution plan), size (get that after creation), and date created.

I tend to create indexes based on need, therefore if storeProc_1 requires 2 indexes I name them as such:

idx1_storeProc_1

I keep this convention going across tables as well and just incrementing the idxVALUE by 1.  So you may come across a table that has idx5_storeProc_1, you can easily see that it is the 5th index for use within storeProc_1

Leave a Reply

Your email address will not be published. Required fields are marked *