Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aman popli
Indexes in SQL Server are similar to the indexes in books.
They help SQL Server retrieve
the data quickly.
There are clustered and nonclustered indexes.
A clustered index is a special type of index
that reorders the way in which records in the table are
physically stored. Therefore table
can have only one clustered index. The leaf nodes of a
clustered index contain the data
pages.
A nonclustered index is a special type of index in which
the logical order of the index
does not match the physical stored order of the rows on
disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain
index rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the types of indexes.
How can you find out how many rows returned in a cursor?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the purpose of object explorer and its features? : sql server management studio
What are the advantages of mirroring?
Define right outer join?
What is model database in sql server?
What is 2nf normalization?
What does the not null constraint do?
What are trace flags?
What is Lock table in SQL?
Define right outer join in sql server joins?
What is a transactions?
how to do partition in sqlserver
Explain time data type in sal server 2008?
