Interested to Buy Any Domain ? << Click Here >> for more details...
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 contrast between sql and pl/sql?
What is difference between equi join and natural join?
What is the sql server 2000 version number?
Which language rdl files made of?
What new data source types were added in ssrs 2014?
How can you append an identity column to a temporary table?
Define outer join in sql server joins?
How to list all columns in a table using odbc_columns()?
What is sql server replication? : sql server replication
What is the difference between insensitive and scroll cursor?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What are the security related catalog views? : sql server security
List out different types of normalizations in sql server and explain each of them?
Why is replication required on the sql server?
