Re: sort without order by

Hi,

Oracle IOTs are modelled by "clustering" data due to the defined order on the table's primary key. For 8.0.5 there is a serious bug in the optimizer: It performs a FTS (full table scan) for almost all queries, which is the worst thing to do, as db pages are read in logical order (i.e., your disk will go mad :-). In 8i performing a FFS (fast full scan) will run along the leafs of the index-implementing B-tree, which means ordered output.

HTH
  Jörg

> not sure whether I 'd rely on this feature of index-organised tables.
> This behaviour is probably due to the way index-organised tables are
> implemented (as an B* index..),
Received on Fri Nov 19 1999 - 02:56:02 CST