Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what role entity and relationship play in an ER diagram.
what is unique and xaml nonclustered index
How can we delete Duplicate row in table?
What is ssrs?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
System requirements for sql server 2005 express edition?
What are the differences between user defined functions and stored procedures?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is simple indexing method?
How to get the definition of a user defined function back?
how to trace the traffic hitting a sql server? : Sql server database administration
What is difference between delete and truncate commands?
Explain contrast amongst grouped and non-bunched records?
How data can be copied from one table to another table?
What is transactional replication?