; Steve,
> >
> > That query took about 52 seconds to run.
> >
> > Thanks
> > Rick
> >
> >
> > "Stephane
> > Faroult" To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
>
> > 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.
> 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
pients of list
>ORACLE-L <[EMAIL PROTECTED]>
> ecorp.com> Subject: RE: More info on sql query
>running slow
> Sent by:
> [EMAIL PROTECTED]
> m
>
>
>
phane
Faroult" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: More info on sql query
running slow
àãø éçéàì
.co.il> cc:
Sent by: Subject: RE: More info on sql query
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
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,
>
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
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
10 matches
Mail list logo