Re: compressed index and partition table?

Kate Lin wrote:
>
> Hi,
>
> this table has 36 million rows, we did not use IOT and our application will
> not update primary key frequently.
>
> thanks a lot

Performance will depend. If you are regularly scanning the index, then because you are getting more rows per block, the scans will be more efficient (at the cost of slightly more cpu). If you are doing unique probes, then you probably won't get any gain (but you may see a better hit ratio)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."