how many types of indexes are there in sql server 2008

asked Mar 20, 2017 at 01:47 PM in Default

What did you try as your search terms in Google or Bing or Yahoo or whatever other search engine you may have used?

Mar 20, 2017 at 02:18 PM ThomasRushton ♦♦

(comments are locked)

3 answers:

answered Mar 28, 2017 at 07:36 AM

(comments are locked)

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

answered Mar 28, 2017 at 09:44 AM

DazyParker
69 ● 2 ● 1

The question was about SQL Server 2008 - the two you mention don't come in until 2014.

Mar 31, 2017 at 08:21 AM ThomasRushton ♦♦

(comments are locked)

Some of them are explained here in brief...

answered Mar 31, 2017 at 05:00 AM

jason_clark03
421 ● 3 ● 7

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

asked: Mar 20, 2017 at 01:47 PM

Seen: 75 times

Last Updated: Mar 31, 2017 at 08:21 AM