Hi all, In this article I am trying to explain “How to define indexes in SQL Server”. For this article am going to use Products table of Northwind database. This article deals with - * Query Optimizer
* Creating an Index
* Creating Unique Index
* Creating Clustered Index
* Creating Full-Text Index
* Changing properties of Index
* Renaming an Index
* Deleting an Index
* Specifying Fill factor of Index
* Create XML Index
* Delete XML Index
* Advantages of Indexing
* Disadvantages of Indexing
* Guidelines for Indexing ExplanationEvery organization has its database and each and every day with the increase in the data volume these organizations has to deal with the problems relating to data retrieval and accessing of data. There is need of system which will results into increase in the data access speed. An index (in simple words it like index of any book eg. While searching a word in Book we use index back of book to find the occurance of that word and its relevant page numbers), which makes it easier for us to retrieval and presentation of the data. An Index is a system which provides faster access to rows and for enforcing constraints. Read more: Codeproject
* Creating an Index
* Creating Unique Index
* Creating Clustered Index
* Creating Full-Text Index
* Changing properties of Index
* Renaming an Index
* Deleting an Index
* Specifying Fill factor of Index
* Create XML Index
* Delete XML Index
* Advantages of Indexing
* Disadvantages of Indexing
* Guidelines for Indexing ExplanationEvery organization has its database and each and every day with the increase in the data volume these organizations has to deal with the problems relating to data retrieval and accessing of data. There is need of system which will results into increase in the data access speed. An index (in simple words it like index of any book eg. While searching a word in Book we use index back of book to find the occurance of that word and its relevant page numbers), which makes it easier for us to retrieval and presentation of the data. An Index is a system which provides faster access to rows and for enforcing constraints. Read more: Codeproject