Re: More info on sql query running slow

2002-03-21 Thread Igor Neyman
; Steve, > > > > That query took about 52 seconds to run. > > > > Thanks > > Rick > > > > > > "Stephane > > Faroult" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >

Re: More info on sql query running slow

2002-03-20 Thread Greg Moore
> > weigh cost of adding a extra index. > > Maybe you can add this column to an existing index. Specifically, instead of the FK index on the FK column(s) only, add the flag column to the FK index. It will still work as a FK index, and you'll optimize this SQL without adding an additional index.

Re: More info on sql query running slow

2002-03-20 Thread Greg Moore
> weigh cost of adding a extra index. Maybe you can add this column to an existing index. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: More info on sql query running slow

2002-03-20 Thread Stephane Faroult
pients of list >ORACLE-L <[EMAIL PROTECTED]> > ecorp.com> Subject: RE: More info on sql query >running slow > Sent by: > [EMAIL PROTECTED] > m > > >

RE: More info on sql query running slow

2002-03-20 Thread Rick_Cale
phane Faroult" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: More info on sql query running slow

RE: More info on sql query running slow

2002-03-20 Thread Rick_Cale
àãø éçéàì .co.il> cc: Sent by: Subject: RE: More info on sql query

RE: More info on sql query running slow

2002-03-20 Thread Stephane Faroult
Rick, Curious to know how this would perform : SELECT COUNT(a.phy_contract_id) FROM accrued_and_paid a, (select phy_contract_id from phy_contracts where company_id = 16 and contract_type = 'IC') b WHERE a.hold_payment_flag = 'Y' AND

RE: More info on sql query running slow

2002-03-20 Thread אדר יחיאל
ar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wed, March 20, 2002 3:58 PM > To: Multiple recipients of list ORACLE-L > Subject: More info on sql query running slow > > Hi All, >

RE: More info on sql query running slow

2002-03-20 Thread Hallas John
Title: RE: More info on sql query running slow The query in itself seems quite well optimised in my opinion, although 30 seconds does seem quite long relative to what is possible. What I do not understand is why the query uses the PCON_CMPY_FK index on the PHY_CONTRACTS table when that

More info on sql query running slow

2002-03-20 Thread Rick_Cale
Hi All, Oracle 8.1.6 I have 2 tables which have been analyzed. The query takes about 30+ seconds to run. If I run it many times it is faster as data gets loaded into buffer cache. I want to optimize when that is not the case. All the fields in the query have a separate index created EXCEPT for