Re: Is this a good situation for an Index ?

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f72d3c1$0$13416$afc38c87_at_news.optusnet.com.au...

>
> I can't agree with that last one. If it's to be unique, then constrain it
> to be unique with a unique *constraint*, and never mind whether the index
> is unique or non-unique. In fact, non-unique has advantages. And also in
> fact, Oracle has been recommending people *not* to create unique indexes
> since at least the 8.1.6 doco.

Something equally interesting: if you create a unique index, you create an implicit unique constraint on the column(s) involved. Latest versions, of course. Could this be a "preview" of things to come?

Aside: the presentation thing on 10G today was quite interesting. As usual, "Dr.DBA" stole the show. Was good to catch up with him after a 7 year pause!

Very interesting stuff is all I can say. And here goes a prediction: ASSM and ADM will replace all other methods in Wintel before M$ brings out Longhorn server. Any guesses why?

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam