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 are the advantages of using stored procedures in sql server?
What is 1nf 2nf and 3nf?
Explain about merge replications?
Explain difference between cross join and full outer join?
What is sql stored procedure?
Can we take the full database backup in log shipping?
What is the Control Flow in SSIS
Define left outer join?
What is side by side migration in sql server?
What is the difference between a unique key and primary key?
Explain iaas, paas and saas?
How to identify current user in ssrs report?
What is sql profiler. What are the default templates with it? : sql server database administration
What encryption security is available in sql azure?
Define primary key?
