Re: Creating Table as select...

From: hrishy <hrishys_at_yahoo.co.uk>
Date: 9 Feb 2004 01:01:12 -0800
Message-ID: <4ef2a838.0402090004.6eed2920@posting.google.com>

Hi Daniel

The statements below are requiremnets for datawarehousing type of application esepecially during ETL requirements..or probably using updateable replication
.But nevertheless these samm things are great eyeopeners manytimes.Tahnk you very much for taking your time out and responding.

regards
Hrishy

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076170588.168313_at_yasure>...
> hrishy wrote:
>
> > Hi Daniel
> >
> > Can you please exaplin me why..that i should prefer unique constraints
> > over unique indexes.
> >
> > regards
> > Hrishy
>
> Can't defer unique index ... can defer unique constraint
> Can't disable unique index ... can defer unique constraint
> Only option with a unique index is to drop it
>
> Create a unique constraint and look at the entries in user_constraints
> and user_indexes ... try the same thing after building a unique index.
Received on Mon Feb 09 2004 - 03:01:12 CST