InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When Do We Need To Index Tables? |
|
Answer» We need to INDEX tables only when the QUERIES will be selecting a small portion of the table. If our query is retriving rows that are greater than 10 or 15 percent of the total rows in the table, we MAY not need an index. We need to index tables only when the queries will be selecting a small portion of the table. If our query is retriving rows that are greater than 10 or 15 percent of the total rows in the table, we may not need an index. |
|