RE: Query question

From: Bala, Prakash <prakash.bala_at_cingular.com>
Date: Thu, 05 Apr 2001 12:22:28 -0700
Message-ID: <F001.002E31C3.20010405122228@fatcity.com>

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: 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).
--

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

Author: Bala, Prakash
  INET: prakash.bala_at_cingular.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 - 14:22:28 CDT