Query question

From: Mukesh Ghildiyal <mcgoracle_at_yahoo.com>
Date: Thu, 05 Apr 2001 11:20:42 -0700
Message-ID: <F001.002E30D5.20010405112613@fatcity.com>

Hello gurus
please help

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.

thank you very much

Please help

mcg

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mukesh Ghildiyal
INET: mcgoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 05 2001 - 13:20:42 CDT