Sql server 2000 data volume problem

[spaliwal]

Hi Gurus,

I have Three tables -

TableA 6 lac recs
TableB 2 Lac recs
TableC 1 Lac recs

Table A is is in frequent is in Insert / Update/ Delete ,
Pl. anybody who worked in large data volume in sql server 2000 can suggest me will it create any problem while accessing Join of TableA , TableB and TableC , can it help to create a clusterd index on joined column ,pl. also let me know if clustered index cause further inserts will slow.

TIA

Sheilesh

 

[miq]

hi,
yes clustered index can improve preformance even non clustered indexs are very important. Joining three tables is always a resource intensive task.
Clustered index should be created carefully i suggest use non clustered indexs (if not exists create them otherwise update their statistics).

Run your query at off-peak hours.


Bye
miq