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 mapping schema?
How to write an inner join with the where clause in ms sql server?
How can you insert null values in a column while inserting the data?
Does order by actually change the order of the data in the tables or does it just change the output?
How use inner join in sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the different ways you can create databases in sql server?
List out the different types of locks available in sql server?
What are the advantages of using stored procedures in sql server?
What is Lock table in SQL?
Explain powershell included in sql server 2008?
What are “unrepeatable reads”?
How to count rows with the count(*) function in ms sql server?
what are user defined datatypes? : Sql server database administration
what is a live lock? : Sql server database administration
