Optimizing select and joins

From: Craig Alexander <craig_at_itas.net>
Date: Tue, 18 Jan 2000 13:49:36 GMT
Message-ID: <Qb_g4.191$Xb7.26348@sapphire.mtt.net>

Does anybody know how it would be possible to optimize the following SQL

SELECT
    B."VALUE", ROUND(SUM(ACCT_BACKUP.DELTA)/3600,2) FROM
    USR, ACCT_BACKUP, SVC_DATA A, SVC_DATA B, SVC_DATA C WHERE
    (USR.BILLINGID = ACCT_BACKUP.BILLINGID)     AND (ACCT_BACKUP.TYPE= 2)
    AND (ACCT_BACKUP.CREATED >= '01-JAN-2000' AND ACCT_BACKUP.CREATED <= '05-JAN-2000')
    AND (A.ATTR_NAME = 'PRICING_PLAN_NUMBER' AND A.ENTITY_ID = 50001042)     AND (B.ATTR_NAME = 'PRICING_PLAN_TITLE' AND B.ENTITY_ID = 50001042 AND B.SUBSCRIPT = A.SUBSCRIPT)
    AND (C.ATTR_NAME = 'CHOSEN_PRICING_PLAN' AND (C.ENTITY_ID = USR.USR_ID) AND (C.VALUE = A.VALUE)) GROUP BY B.VALUE We are running an Oracle 7 DB. At the moment the SQL statement does execute and return records, but it takes a very long period of time. If anybody can help it would be greatly appreciated.

Thank You

--
Craig Alexander
Island Tel Advanced Solutions Received on Tue Jan 18 2000 - 07:49:36 CST