Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Should I study Oracle 8i/9i or 9i directly/
"Jeff" <jeff_at_work.com> wrote in message
news:ajbmve$f31$2_at_cronkite.cc.uga.edu...
> In article <3d58c295_at_dnews.tpgi.com.au>, "Howard J. Rogers"
<howardjr2000_at_yahoo.com.au> wrote:
>
> >don't, not with our current material. You learn things which will
completely
> >mislead you in 8i (such as 'don't index foreign key columns because
they're
> >not needed any more' [paraphrasing wildly]). And you don't learn things
>
> I'm 8i-trained, just dipping toes into 9i and haven't had the 9i upgrade
> course yet.
>
> Is the above true about not indexing foreign keys??? As the original
reason
> behind this was to avoid a table lock on the child table, has this changed
in
> 9i?? If so, I've got some some schema changes to make.
No, practically it hasn't changed. Though the 9i material will tell you that there is, and I quote, "less need for indexes on foreign keys". Which is total rubbish, as any decent instructor will very readily demonstrate.
The need is as big as it's ever been.
Regards
HJR
Received on Wed Aug 14 2002 - 04:03:42 CDT