InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Purpose Of Indexes? |
|
Answer» An index is a MECHANISM that can be used by the SQL query optimizer to make table access more performant. Indexes enhance DATA access by providing a moreor- less direct path to stored data and AVOIDING the necessity to perform full table scans to LOCATE the small number of ROWS you typically want to retrieve or update. An index is a mechanism that can be used by the SQL query optimizer to make table access more performant. Indexes enhance data access by providing a moreor- less direct path to stored data and avoiding the necessity to perform full table scans to locate the small number of rows you typically want to retrieve or update. |
|