SQL Server 2005 – Defining Indexes In this tutorial you will learn about Defining Indexes in SQL Server 2005 – clustered and non clustered indexex, The Query Optimizer, to create an index, To create a unique index, To create a clustered index, To create full-text indexes, To change index properties, To rename an index, to delete an index, To specify a fill factor for an index, To create an XML index and To delete XML Indexes. When data volumes increase, organizations are faced with problems relating to data retrieval and posting. They feel the need for a mechanism that will…