SQL tuning advice

From: <Rick_Cale_at_teamhealth.com>
Date: Tue, 19 Mar 2002 13:52:37 -0800
Message-ID: <F001.0042DD41.20020319135237@fatcity.com>

Hi DBAs,

Oracle 8.1
We have the following query where each field name is a separate index. My question is does it matter the order of table names in the from clause. I assume
that phy_contracts is the driving table. Also what guidelines should I use in the predicate,i.e.,cardinality,etc.? The tables are analyzed.

Thanks
Rick

SELECT COUNT(a.phy_contract_id)
FROM accrued_and_paid a, phy_contracts b WHERE a.hold_payment_flag = 'Y'

AND         b.phy_contract_id = a.phy_contract_id
AND         b.company_id = 16
AND        b.contract_type = 'IC';

--

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

Author:
  INET: Rick_Cale_at_teamhealth.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 Tue Mar 19 2002 - 15:52:37 CST