Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by SQL*Net?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How to return the date part only from a sql server datetime datatype?
What is the use of RDBMS?
What is the server name for sql management studio?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How are the unique and primary key constraints different?
What are the limitations/drawbacks or ssrs 2008 r2?
Can you explain what are various ways to enhance the ssrs report?
How to create database with physical files specified in ms sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Can you leave a union at any time?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What are binary string data types in ms sql server?