What indexes do you have on these tables and how many rows are in each
table?
Craig Alexander <craig_at_itas.net> wrote in message
news:Qb_g4.191$Xb7.26348_at_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 - 21:25:47 CST
