Preventing Nested Table Full Access

       I am using a table as a cache for an oracle object type collection.The query to build the object collection is time consuming .So idea is to build the cache object once and store the elements in cache table and when next time its needed then return from cache table itself rather than going through entire process . But the problem is Oracle does a Full Table Scan always when I select from this cache table . So select time increases as number of rows in table increases .Following is the script for what I am using ..

CREATE OR REPLACE TYPE VALUE_arr as table of varchar2(30);

CREATE TABLE OBJECT_CACHE
(

  CACHE_ID           NUMBER,
  DARRAY          VALUE_ARR,
  MARRAY       VALUE_ARR,
  FARRAY   VALUE_ARR,
  AARRAY       VALUE_ARR,

       PRIMARY KEY(cache_id)
)

NESTED TABLE DARRAY STORE AS DARRAY_TBL ,
NESTED TABLE MARRAY STORE AS MARRAY_tbl ,
NESTED TABLE FARRAY STORE AS FARRAY_TBL ,
NESTED TABLE AARRAY STORE AS AARRAY_TBL ,
NESTED TABLE SARRAY STORE AS SARRAY_TBL ;

Select query which I am using is following ..

select query
from OBJECT_CACHE
where darray = value_arr( 'a','b','c','d') and marray =value_Arr('a','b')
and farray = value_arr('a','b');

As of now this table has 1000 rows and select statement is taking nearly 11 secs for fetching the query .

Is there a way to avoid the FTS or is there any other way to work out this solution ?

Thanks,
Anupam

--
http://www.freelists.org/webpage/oracle-l