> -----Original Message-----
> From: Mukesh Ghildiyal [mailto:[EMAIL PROTECTED]]
>
> 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.
