Re: the 20% rule

From: David BL <davidbl_at_iinet.net.au>
Date: Thu, 24 Jul 2008 07:22:26 -0700 (PDT)
Message-ID: <0512f07b-f55f-412f-aa21-46be91fa36f9@v13g2000pro.googlegroups.com>


On Jul 24, 10:01 pm, aark..._at_gmail.com wrote:

> The fastest way to retrieve rows from a table is to access the row
> with exact row id. An
> index is the second fastest way

I'm no expert in oracle, but my understanding is that it provides so called heap organised tables or else index organised tables. The above comment would seem to apply to the former not the latter. Received on Thu Jul 24 2008 - 09:22:26 CDT

Original text of this message