Re: query performance -- revised!

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Wed, 28 May 2003 17:28:18 -0700
Message-ID: <dBcBa.19$we7.173@news.oracle.com>

"Ryan" <rgaffuri_at_cox.net> wrote in message news:CjcBa.120847$823.9640_at_news1.east.cox.net...
> 1. change your Or to an 'IN'
> 2. if Address has less records than the other tables(try it anyway)
> make it a sub-query with an exists
> where exists (select 1 from Address where blah...
> 3. pr.remove_from_mdlocator <> 1
> try to chnage that to an 'IN' not equals can be slow
> 4. Possibly put Address and all its qualifiers in a sub-query with Exists.

Also consider the following:
5. Change the order of the tables in the from clause. Try all the permutations.
6. Add "and exist(select 1 from dual)". Mix it with " and exist(select 2 from dual)" sparingly.
7. Try capital letters in the table names -- optimiser respect those more. 8. Start playing with init.ora parameters. There are too many of those to check all the permutations, but give it a shot. Received on Wed May 28 2003 - 19:28:18 CDT