Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answers were Sorted based on User's Feedback
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 |
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 |
How to use column default values in insert statements in ms sql server?
What is factless fact table? : sql server analysis services, ssas
In what version of sql server were synonyms released?
In which files does sql server actually store data?
What is Online Index Rebuild Operation?
How do I port a number to sql server?
What are the different types of queries?
What is Lock table in SQL?
Differentiate between a primary key and a unique key.
What are the differences between local and global temporary tables?
What do mean by xml datatype?
Explain primary key, foreign key and unique key?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)