Re: Extents, Index, Optimization Q's

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 26 Sep 2002 15:47:03 GMT
Message-ID: <3D932BF7.F09CFBDE@peasland.com>

> I indexed the 22 tables that are opened read and closed, that helped
> marginally.
> All tables have unique indexes, some one mentioned Primary indexing is
> more efficient, is that true?

A Primary Key index performs the same as a Unique index on the same column(s).

Have you tuned your SQL statements? I won't repeat what others have already added, but it seems that you need to take a good look at your SQL statements and tune them first!

HTH,
Brian Received on Thu Sep 26 2002 - 10:47:03 CDT