Saved Bookmarks
| 1. |
What Is An Index Represent In Relational Database Model? |
|
Answer» Index is a way to provide quick access to the data and STRUCTURE. It has indexes maintain and can be created to combine attributes on a relation. Index ALLOWS the QUERIES to FILTER out the searches faster and matching data can be found earlier with simplicity. For example it is same as the book where by using the index you can DIRECTLY jump to a defined section. In relational database there is a provision to give multiple indexing techniques to optimize the data distribution. Index is a way to provide quick access to the data and structure. It has indexes maintain and can be created to combine attributes on a relation. Index allows the queries to filter out the searches faster and matching data can be found earlier with simplicity. For example it is same as the book where by using the index you can directly jump to a defined section. In relational database there is a provision to give multiple indexing techniques to optimize the data distribution. |
|