Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ajit502
Starting Member
6 Posts |
 Posted - 2009-03-17 : 02:42:10
|
| does index always increase performance ?Thanks,ajit |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-03-17 : 03:10:22
|
| Too much of something is bad enough. BUT Too much of nothing is just as tough ...Yes, indexes are helpfull to improve performance BUT when you are really informed when and how to use indexes.http://www.sqlteam.com/article/sql-server-indexes-the-basics |
 |
|
|
pootle_flump
1064 Posts |
Posted - 2009-03-17 : 07:19:00
|
quote:
Originally posted by ajit502
does index always increase performance ?
To give a precise answer to the question, no. |
|
|
|
|
|
|
Index performance