Jay Roy
asked on
clustered index v/s non clustered index (in laymans terms)
Dear experts
I would like to know the difference between index types (with focus on clustered index and non-clustered)index in laymans terms.
We use sql server 2008 and in the Microsoft SQL server management studio when i want to create index i do see following options :
clustered
Non-clustered
Primary XML
Spatial
Any idea what to use when? An explanation in layman's terms will be appreciated.
Thanks.
I would like to know the difference between index types (with focus on clustered index and non-clustered)index in laymans terms.
We use sql server 2008 and in the Microsoft SQL server management studio when i want to create index i do see following options :
clustered
Non-clustered
Primary XML
Spatial
Any idea what to use when? An explanation in layman's terms will be appreciated.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks.
form of
Big thumbs small keyboard