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
Why we need to use secondry database file? though, we can do same work using primary database file also.
How can I tell if sql server is 32 or 64 bit?
Where are stored procedures in sql server?
Can we use max in where clause?
Which Model uses the SET concept
What is change data capture (cdc) feature?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is the filtered index?
What do you understand by recursive stored procedures?
Explain four layers of abstraction microsoft architectured?
What is a fill factor?
How to use user defined functions in expressions?
What are dml triggers and types of dml triggers?
Explain how dts is used to extract, transform and consolidate data?
What is normalization and denormalization in sql server?
