Share via


SQL Server Indexing Basics

Problem I have seen your
tips on indexing and I think they are great. I am relatively new to SQL Server and need to understand the basics. I need some additional background information to understand what sorts of indexing options are available. Hopefully that can lead me into using some of the additional tips. Can you help me?

Solution As you begin to design and develop databases, be sure to include indexing in that effort. A well thought out
indexing strategy can significantly improve the data access layer and overall user experience. However, caring for the database indexes is not a one time event. As your application changes as well as when users start to use the application in new and different ways, your indexes need to reflect these changes. In addition, as with anything else, indexes need to be maintained. So be sure to have your indexes included in the regularly scheduled maintenance process.

With all of this being said, let's start to cover some of the basic indexing information. In this tip, we will try to simplify a number of complex and interdependent topics. As such, the goal of this tip is to introduce the topics and provide additional references for an expanded information. If you are looking for more intermediate and advanced information, check out the indexing category . In addition, check out these resources if you are looking into Full Text Search or XML indexes as opposed to traditional relational engine indexes . With that being said, let's jump in!

The full article is here : https://www.mssqltips.com/tip.asp?tip=1793 _us

image