RE: Query question

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 05 Apr 2001 12:11:11 -0700
Message-ID: <F001.002E31AA.20010405120623@fatcity.com>

> -----Original Message-----
> From: Mukesh Ghildiyal [mailto:mcgoracle_at_yahoo.com]
>
> I am running following query
> This takes forever to complete.
>
> select pay.gl_date from
> noetix_sys.noetix_current_period off

>   2  ,gl.gl_sets_of_books sob, gl.gl_periods per,
>   3  ar.ar_payment_schedules_all pay
>   4  where
>   5  pay.gl_date between per.start_date and

> per.end_date

>   6  and per.period_set_name||'' =sob.period_set_name
>   7  and per.period_type = sob.accounted_period_type
>   8  and sob.set_of_books_id=26
>   9  and off.application_id=222
>  10  and off.period_type=sob.accounted_period_type
>  11* and off.set_of_books_id=26

>
> Now if I takeout following line
>
> and off.period_type=sob.accounted_period_type
>
> it works
>
> the column  "off.period_type" and
> "sob.acoount_period_type" are both not null
> varchar2(15)  type.
>
> Could anybody has some idea, why its doing that.

Have you looked at the "explain plan" for the two queries? If not, you should probably do so. Received on Thu Apr 05 2001 - 14:11:11 CDT