Answer Posted / sajjan singh
Indexes are data structures that help SQL Server to find
particular rows of data fastly.
In a database, an index allows the database program to find
data in a table without scanning the entire table.
An index in a database is a list of values in a table with
the storage locations of rows in the table that contain each
value.
Indexes can be created on either a single column or a
combination of columns in a table and are implemented in the
form of B-trees.
Clustered Index: "A clustered index is a special type of
index that reorders the way 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."
Non Clustered Index: "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 nodes of a nonclustered index does not consist of
the data pages. Instead, the leaf nodes contain index rows."
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a function and a stored procedure?
How to read data in a table with "select" statements?
What is thr feature of change data capture?
What is postgresql server?
What are the built in functions in sql server?
What do you mean by an execution plan?
How can we rewrite sub-queries into simple select statements or with joins?
How to handle error or exception in sql?
Is null vs coalesce?
What samples and sample databases are provided by microsoft?
What are the different type of replication in sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is the New in SQL server 2008?
How to convert a table data in XML format in sql server?
Can you import Microsoft Excel data to SSRS?
