Monday, August 26, 2013
Sql Server: Understanding on indexes
Indexes are created to provide faster data access during specific data fetch and retrieval form huge data tables.
There are various types of indexes in sql server
a. Clustered Index
b. Non clustered index
g. Full text
h. Index with computed column
i. Index with non computed column
Mainly we will discuss here about Clustered index and non clustered index
Before going through understanding about indexes, let’s focus on the questions that one faces.
o. How does indexing work?
p. What does a table with no index called?
q. Which index are faster clustered or non-clustered?
r. When should we use clustered index?
s. When should we use non clustered index?