Re: ORA-00054: resource busy... - what on Earth?

"harry" <a_at_abc.com> schrieb im Newsbeitrag news:nfrQc.188$M_2.2509990_at_news-text.cableinet.net...
> Thanks for the replies so quickly, I don't have any FK's indexed at the
> moment - this looks like the cause then?
>
> I'm going to put indexes now on every single one of them & see if it makes
a
> difference!
>

Not indexing FKs is one of the most severe performance killers !

But of course do not over-index the table, only the FKs and frequently queries columns only.

HTH, Jan Received on Fri Aug 06 2004 - 01:17:14 CDT