|
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..);........
|
