Not a good idea. Indexes are used for improve select query performance.

Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?

Question Posted / laxman

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

Please Help Members By Posting Answers For Below Questions

What is the latest version of microsoft sql server?

1116

How will you go about resolving deadlocks?

1033

what method you can use to reduce the overhead of Reporting Services data sources?

268

What is query and its types?

954

What is a with(nolock)?

1025

Which are the important points to note when multilanguage data is stored in a table?

1067

Explain what is log shipping?

1192

how many type of indexing in database?

1019

What is read uncmmited?

1115

What is snapshot replication?

1098

What is difference between aggregate and analytic function?

976

Explain the xml support sql server extends?

1082

What is system stored procedures?

1083

How you can get a list of all the table constraints in a database?

999

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1119