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
What samples and sample databases are provided by microsoft?
How to concatenate two character strings together?
Explain how many types of relationship?
What is the difference RDBMS and Graph Database?
What is the difference between set and select?
How can we delete Duplicate row in table?
What are the properties of the transactions?
What is transact-sql ddl trigger?
What is difference between clustered and non clustered index?
What is sql server query analyzer?
Explain iaas, paas and saas?
What is tempdb in sql server?
What does set rowcount do?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is the osql utility?
