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_at_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 - 16:22:26 CEST

This message: [ Message body ]
Next message: David BL: "Re: Guessing?"
In reply to aarklon_at_gmail.com: "the 20% rule"
Next in thread: Bob Badour: "Re: the 20% rule"
Reply: Tim X: "Re: the 20% rule"
Reply: David BL: "Re: the 20% rule"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message