InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
A Table Is Having Few Rows, Should You Create Indexes On This Table? |
|
Answer» SMALL tables do not require INDEXES; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the column is not USED in any of these SITUATIONS, creating an index on the column does not increase performance and the index TAKES up resources unnecessarily. Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the column is not used in any of these situations, creating an index on the column does not increase performance and the index takes up resources unnecessarily. |
|