Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn about index design, and the suitable candidates for index key and non-key columns. I this article, you will also learn about various SQL Server indexes options, such as pad-index and fill-factor.