Re: Index organised table

1, logical io should also be less compared to a heap organized table, if you do range scan on the pk column. PIO should be same. I do not see any reason IOT provide better hit ratio.

2. index block split.

3. performance also depends on whether it is accessing accroding to pk, or secondary index. Received on Fri Dec 02 2005 - 09:47:53 CST