Hi folks,

I tried to analyze table, index and create histogram. But
query is still not using index on Big table. Also, I tried
to put big table in BUFFER_POOL_KEEP. But, still there is
physical read on this query. Reads are propotional to Number
of rows that satisfy category_id crieteria.

e.g. for category_id = 10, I have 20000 rows and 1400
physical reads.

for category_id = 9, I have 10000 rows and 800 physical
reads.

for category_id = 5, I have 2000 rows AND physical read=0.

I was thinking to put this table in KEEP pool to avoid
disk reads reducing overall COST of query. We need to run
this query every 2 minutes for multiple sessions.

thanks for all your help,

Nilesh