Sql Server Indexes Interview Questions and Answers

Indexes help us to find data faster. It can be created on a single column or a combination of columns........
Use of intexes slow down Data modification operations (such as INSERT, UPDATE, DELETE).........
A clustered index reorders the way records are stored. A non clustered index is in which the logical order of the index does not match the physical stored order of the rows on disk......
Unique index is the index that is applied to any column of unique value........
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data........
The fill factor option is provided for smoothening index data storage and performance........
Usually the data keeps getting added, deleted, or updated in the table due to which the fill factor is implemented during the index creation itself........
A clustered index is a good choice for searching over a range of values. After an indexed row is found, the remaining rows.......
Full text indexes are stored in the file system and are administered through the database.......
A fill factor is a specification done during the creation of indexes so that a particular amount of space can be left on a leaf level page........
The characteristics of the indexes are: They fasten the searching of a row. They are sorted by the Key values........
Types of indexes: Clustered: It sorts and stores the data row of the table or view in order based on the index key.........
Allow the server to retrieve requested data, in as few I/O operations.......
When there is large amount of data. For faster search mechanism indexes are appropriate........
CREATE INDEX index_name ON table_name (col_1,col_2..);........