Re: Separating data, index objects

From: Mark A <nobody_at_nowhere.com>
Date: Tue, 5 Jul 2005 23:22:12 -0600
Message-ID: <TdGdna_lxogZ91bfRVn-iw@comcast.com>

"StenR" <rognes_at_gmail.com> wrote in message news:1120626260.520301.111810_at_g14g2000cwa.googlegroups.com...
>
> Have a go at this one:
>
> http://groups-beta.google.com/group/comp.databases.oracle.server/browse_frm/thread/2e160ea9b58005b8/f7aada93a28393c6?q=separate+index+table+performance&rnum=4&hl=en#f7aada93a28393c6
>

Yes, in the thread link above from 2002, Daniel seems shocked that someone would say that separting tables and indexes makes no performance dififfernce.

Here is the exact statment that Daniel posted:

"can't believe it [separation of indexes from their tables is a management nicety, not a performance necessity] either. Please explain Howard.

And please don't just throw out jargon like RAID and striping. This statement appears to fly in the face of more than a few books by well respected authors (not that you aren't one yourself now) as well as a lot of HTM and PDF files put out on technet."

Looks like we caught Daniel with his hand in the cookie jar once again. Received on Wed Jul 06 2005 - 00:22:12 CDT