Re: Index ignored

"Jim Poe" <jpoe_at_fulcrumit.com> wrote in message news:MPG.17b9c6e12cf0e538989685_at_news.callatg.com...
> Hi,
>
> Looking at the sql and the plan, can anyone tell me why there is a TABLE
> ACCESS FULL on FIT_DBA.QUOTE? QUOTE_ID is a unique primary key.
>
> SELECT A.ST_ID, NULL as CNTY_ID, NULL as CITY_ID, NULL AS ZIP_ID
> FROM QUOTE Q, SUBM S, INSD I, OFFICE_ADDR O, ADDR A
> WHERE Q.QUOTE_ID=10000
> AND S.SUBM_ID = Q.SUBM_ID
> AND I.INSD_ID = S.INSD_ID
> AND O.OFFICE_ID = I.INSD_ID
> AND A.ADDR_ID=O.ADDR_ID
> and AMS_PROC.Val_Carr_State(10000, A.ST_ID, 'Q')='T'
>
> Description cost card bytes
>
> SELECT STATEMENT, GOAL = CHOOSE 5 1 54
> HASH JOIN 5 1 54
> NESTED LOOPS 3 6 276
> NESTED LOOPS 2 1 38
> NESTED LOOPS 2 1 34
> TABLE ACCESS FULL FIT_DBA QUOTE 1 1 26
> TABLE ACCESS BY INDEX ROWID FIT_DBA SUBM 1 5 40
> INDEX UNIQUE SCAN FIT_DBA SUBM_PK 5
> INDEX UNIQUE SCAN FIT_DBA INSD_PK 2 8
> TABLE ACCESS FULL FIT_DBA ADDR 1 6 48
> TABLE ACCESS FULL FIT_DBA OFFICE_ADDR 1 551 4408
>
>
> Thanks
>
> --
> Jim Poe
> Fulcrum InteTech, Inc.
> <jpoe_at_fulcrumit.com>

There are histograms on the affected column? CBO is indifferent to something being a primary key.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address