Evaluating the Usage of Index in Database

Week 4 Discussion 2: Making Sure Our Indexes Help
Student Full Name
Institutional Affiliation
Course Full Title
Instructor Full Name
Due Date
Week 4 Discussion 2: Making Sure Our Indexes Help
An index refers to an on-disk structure linked with a view that facilitates faster retrieval of data from the view. It holds keys created from one or several columns in the view and stored in a B-tree structure to allow SQL servers to locate the row or rows related to the critical values promptly and efficiently. Indexes are pointers to data in a database and should therefore be placed to help our queries. However, to better assist in finding required data from a large pool of information, indexes must be optimized. For improved performance tuning of SQL server index, one should first understand the effect of data...