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 |
|
sushma patle
Starting Member
15 Posts |
 Posted - 2008-05-20 : 07:45:09
|
| When to use index and when not to use index. Remember use of index will not always improve the performance. spatle |
|
|
kartik.kaveeshwar
Starting Member
18 Posts |
Posted - 2008-05-20 : 07:58:37
|
| use indexes on those columns which you require frequently in where conditions of your query.this will make the data retreival faster. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-20 : 08:14:53
|
Ask your teacher WHEN index does not improve performance in SELECT statements.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-20 : 08:30:30
|
quote:
Originally posted by sushma patle
When to use index and when not to use index. Remember use of index will not always improve the performance. spatle
Which test are you taking? |
|
|
|
|
|
|
index