Re: Performance problem: anything else I can do to make this faster?

On 3 Mar 2005 09:45:53 -0800, "Steve C" <sgcjr_at_yahoo.com> wrote:

>One thing: I haven't put primary or foreign keys on my tables. As a
>rule we don't rely on the database to do constraint checking. Would
>this figure into the optimizer's decisions around join strategies, etc?

• sarcasm mode on I would recommend replacing the database by ordinary O/S files. It won't be any faster, and it would be anymore inconsistent than the system you now have, but at least you don't pay big bucks anymore for technology you don't use anyway.
• sarcasm mode off.

Of course it will. Basically the optimizer won't find any 'ordinary' nested loop join between two tables, and it will resort to full table scans, index fast full scans, sort/merge joins and hash joins at random moments.

--
Sybrand Bakker, Senior Oracle DBA