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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.431 / Virus Database: 242 - Release Date: 12/17/2002
Oracle LazyDBA home page