Hi Regis,

But i rad somewhere if clustered index is not on incrementive key (o/p of a
sequence) it will slow down further inserts.I want to know will it a
significant slow in inserts.

Thanks,

Sheilesh

----- Original Message -----
From: "Regis Biassala" <Regis.[Email Address Removed] "Shailesh Paliwal" <[Email Address Removed] Monday, December 30, 2002 6:32 PM
Subject: RE: Sql server 2000 data volume problem


> a CLUSTERED INDEX is the way to go....it reduces space and improves
> performance...
>
>
> -----Original Message-----
> From: Shailesh Paliwal [mailto:[Email Address Removed] Sent: Monday, December 30, 2002 12:58 PM
> To: LazyDBA.com Discussion
> Subject: Sql server 2000 data volume problem
>
>
> 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
> *********************************************************************
> This electronic transmission is strictly confidential and intended solely
> for the addressee. It may contain information which is covered by legal,
> professional or other privilege. If you are not the intended addressee,
> you must not disclose, copy or take any action in reliance of this
> transmission. If you have received this transmission in error,
> please notify the sender as soon as possible.
>
> This footnote also confirms that this message has been swept
> for computer viruses.
> **********************************************************************
>
>


---
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