Hi there ...
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                       Object Name     Rows    Bytes   Cost    
SELECT STATEMENT Hint=CHOOSE                                                              
  SORT GROUP BY                              60                                           
    TABLE ACCESS FULL   MY_TABLE             180                                          


this is my query with varrary
SELECT   a.id,
         a.address
FROM     my_table a, TABLE(a.no_of_car) b

Operation                     Object Name       Rows    Bytes   Cost    
SELECT STATEMENT Hint=CHOOSE                         1310                                    
  SORT GROUP BY                              459     1310                                    
    NESTED LOOPS                                73 K    10 M    101                                     
      TABLE ACCESS FULL MY_TABLE             1 K                                          
      COLLECTION ITERATOR PICKLER FETCH                                                                 


regards
kang bedjo

Reply via email to