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

Explain in details security in SQL azure?

121

How to list all stored procedures in the current database using ms sql server?

1137

How many types of schemas are there?

1043

What does truncate do?

943

What is difference between primary key and foreign key?

907

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

What is a bit datatype?

990

How to enforce security in sql server? : sql server security

1111

What is the difference between nvl and nvl2?

981

Do you know what is lock escalation?

1014

Can you roll back the ddl statement in a trigger?

978

What is the boxing and unboxing concept in .net?

919

What is the purpose of a table?

960

How to insert data into an existing table?

981

What is the difference between function and stored procedure in sql server?

1081