In terms of performance, there is no point in indexing a table if ____.
A) several of its attributes are not used as search fields
B) the number of rows of the table is very large
C) the number of rows of the table is very small
D) the number of columns of the table is fairly large
E) the number of columns of the table is fairly small

Question

Quizplus · Accepted Answer

If the number of rows of the table is very small, then indexing may actually decrease performance rather than improve it. This is because the overhead of maintaining the index may outweigh any gains in query speed. However, if the number of rows is very large, indexing can greatly improve performance. The number of columns is not necessarily a factor in whether or not to index a table. The relevancy of attributes as search fields is important, but it's not the only factor to consider.

In Terms of Performance, There Is No Point in Indexing