Answer / 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.

Answer / laxman

Not a good idea.

Indexes are used for improve select query performance.
indexes will be useful when the data is more and more.

Answer / 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.

what is sql injection?

2 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

How do SQL server 2000 and XML linked?

2 Answers  

---

Can we use where and having clause together?

0 Answers  

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

i want table name basis on column name.

5 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

What is the difference between primary key and unique constraints?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---