Re: Granting table privileges

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 11 Apr 2003 19:41:48 +0200
Message-ID: <e8vd9v4aao15qecggmuffvnnf4rhu4qr4f@4ax.com>

On 11 Apr 2003 13:36:53 GMT, Chuck <chuckh_at_softhome.net> wrote:

>
>I would disagree with this. There's no cost involved in separating indexes
>from their tables and there still is the possibility that doing so can
>reduce disk head contention. Sure, we've got many more join operations now
>than just nested loops, but the optimizer still picks that at times and you
>still will have times where the index blocks and table blocks that you're
>after are on the same spindle regardless of how much striping is involved.
>RAID, storage abstraction, and new join operations have certainly reduced
>the possibility of disk head contention, but they have not completely
>eliminated it.

To avoid re-discussing this myth, please read the thread in the Google archives. It contains sample code demonstrating it is only a management nicetie.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 11 2003 - 12:41:48 CDT