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 is a trigger and its types?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is Dependency Injection and provide example?
What does asynchronous call backs means?
What is the difference between implicit and explicit transaction?
How to enter comments in transact-sql statements?
What is the recursive stored procedure in sql server?
What is report subscription?
Explain what is dbcc?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is a domain constraint give an example?
How to loop through returning rows?
Can we store videos inside the sql server table?
What is PROJECTION Operation?
Explain log shipping?
