Re: Optimizing select and joins

Hi.

 Are you using COST or RULE based optimizer?  Post :

1. EXPLAIN
2. What indexes ( with columns ) exists for each table?
3. What is the row count for each table?

 Michael.

In article <Qb_g4.191$Xb7.26348_at_sapphire.mtt.net>,   "Craig Alexander" <craig_at_itas.net> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 15:05:45 CST