Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
- 3 Answers
- 4916 Views
- I also Faced
- E-Mail Answers
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 compare the top two records using sql?
How to convert numeric values to integers in ms sql server?
How to create hyperlink from returned sql query ?
What is awe?
What is lock escalation? : sql server database administration
Is sql server 2016 free?
What is the difference between a primary key and a unique key? Are they the same?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Does an index slow down updates on indexed columns?
what are the different ways to return the rowcount of a table?
What is set nocount on and what is set nocount off?
What is proper subset of candidate key?
How to insert data with null values?
Explain microsoft sql server functions?
In which sql server version report builder introduced?
