Would it be a good idea to create an index on a table that always contains 10

Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?

Question Posted / vanitha.s

3 Answers
4901 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Would it be a good idea to create an index on a table that always contains 10 records? Why or why ..

Answer / bharathi

No it is not a good idea. Indexes are very expensive to
maintain. Indexes are created mainly to improve performace.
If there are only 10 rows in a table, creating index would
not make any difference in the performace.

Is This Answer Correct ?

5 Yes

0 No

Would it be a good idea to create an index on a table that always contains 10 records? Why or why ..

Answer / laxman

Not a good idea.

Indexes are used for improve select query performance.
indexes will be useful when the data is more and more.

Is This Answer Correct ?

3 Yes

0 No

Would it be a good idea to create an index on a table that always contains 10 records? Why or why ..

Answer / subhash

No it's not a good idea.

Table scan would be fine for smaller tables with less records. Moreover indexes need disk space. It's not necessary to create an index and waste the disk space.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer