Hi
I have a table with 10 columns, and row size is 261 and index size
is 117.
I need indexes on these columns.
1. userid, startdate
2. userid, wcc
3. wcc, startdate
4. sesssionid ( I do not do query on this, But it is primary key for
making row unique)
I need to know about these problems
1. Is it slows down to have too many index. If it slows down for
insertion and delete it is
OK. But is it slows down "select " also?
2. If I decrease row size, i.e dropping some of coulmns, does it improve
"select" performance.
3. Is there any order for creating indexes.
4. How to do update statistics for this combination
Right now I do have indexes on 2,3,4(the listed one). I have data
about 400,000 rows. It is slow
many times.
Could you please mail me
sukumar@gte.net
Thank you
Sukumar Konduru