Mukesh, did you check the explain plan for both queries?
-----Original Message-----
Sent: Thursday, April 05, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bala, Prakash
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
