Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answer Posted / 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 View All Answers
How to connect Azure federated root database and apply federation in entity framework?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is the purpose of the tempdb database?
How to create a view on an existing table in ms sql server?
What does asynchronous call backs means?
What is unique key constraint?
Explain the rules for designing files and file groups in sql server?
Explain different types of lock modes in sql server 2000?
Why people hate cursor?
Do comments need to go in a special place in sql server 2005?
How to download and install the scaled-down database adventureworkslt?
What is apply operator in sql?
Explain what is row_number function?
How to create a ddl trigger using "create trigger" statements?
Describe in brief databases and sql server databases architecture.