InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Is An Index Efficient? |
|
Answer» The EFFICIENCY of an index comes from the fact that it lets us FIND necessary rows without having to scan all the rows of a table. They need a fewer disk I/O's than if we had to scan the table and hence are EFFICIENT. The efficiency of an index comes from the fact that it lets us find necessary rows without having to scan all the rows of a table. They need a fewer disk I/O's than if we had to scan the table and hence are efficient. |
|