I have a table with a Varray Columns.
When I used a select operation without access the varray columns the explain plan show fine.. cost = 4
but when I access the Varray columns then I got the cost = 1310
Why ? What happend ? and why oracle did it ?
Someone can explain it to me ?
or how shoud I optimized it ?
this is my query without varrary
SELECT a.id,
a.address
FROM my_table a
Operation
SELECT STATEMENT Hint=CHOOSE
SORT GROUP BY
TABLE ACCESS FULL
this is my query with varrary
SELECT a.id,
a.address
FROM my_table a, TABLE(a.no_of_car) b
Operation
SELECT STATEMENT Hint=CHOOSE
SORT GROUP BY
NESTED LOOPS
TABLE ACCESS FULL
COLLECTION ITERATOR PICKLER FETCH
regards
kang bedjo
