Re: Why this query is sooo slow?!

On 19 May 2004 11:29:50 -0700, ibm_97_at_yahoo.com (JZ) wrote:

>Of course as always, I didn't get any help at all from Oracle tech
>support.

If you submitted the problem as you submit it here (ie without *full* information on all primary keys and foreign keys and all info on indexes on those colums, and above all *without* the explain plan) that is not surprising.
OTS (and this forum ) don't look over your shoulder and this seems like a typical case of leaving out information which is according to you irrelevant.
It strikes me that according to the join condition the table aliased 'n' simply can't be the driving table (because of the join with the table aliased 'ip'). At this point it stops for me, as I don't have an explain plan and your description of the problem is insufficient. You're leaving out too many details.

--
Sybrand Bakker, Senior Oracle DBA