how many types of indexes are there in sql server 2008
how many types of indexes are there in sql server 2008
What did you try as your search terms in Google or Bing or Yahoo or whatever other search engine you may have used?
Refer this link as i found it more suitable for your answer
https://msdn.microsoft.com/en-us/library/ms175049(v=sql.105).aspx
Arshad, Above link has the information about indexes but, two index "Hash" and "Memory-optimizes nonclustered index" in missing. You can read them here:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/indexes
The question was about SQL Server 2008 - the two you mention don't come in until 2014.
Some of them are explained [here][1] in brief... [1]:
https://www.tutorialspoint.com/sql/sql-indexes.htm
