To index database
Query below lists all indexes in the database. Query. select i.[name] as index_name, substring(column_names, 1, len(column_names)-1) as [columns], case 7 Aug 2011 The primary feature of a clustered index is therefore the ordering of the physical data rows in accordance with the index blocks that point to them.