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
Do you know what is a linked server in sql server?
can you instantiate a com object by using t-sql? : Sql server database administration
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
How to get the definition of a trigger back?
what's the information that can be stored inside a bit column? : Sql server database administration
Why is replication required on the sql server?
What is a hint?
Define full outer join?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Give the query of getting last two records from the table in SQL SERVER?
What happens when the SQL Azure database reaches Max Size?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to connect Azure federated root database and apply federation in entity framework?
How to update multiple rows with one update statement in ms sql server?
What is the difference between dataadapter and datareader?
