Re: Oracle's Myth: keep tables and indexes in separate tablespaces

Snid wrote:

>
> So I guess I can see why lots of people think that it's best to separate
> indexes from tables. It doesn't mention that you should only separate them
> for administration purposes mainly.

Quite right. The advice is still there, in plain, unadorned incorrectness, in the performance tuning course notes for Oracle 9i (published in version 2.1 only a few weeks ago).

Oracle are also responsible for promoting the myth that getting a segment into a single extent is good for performance; that PCTINCREASE 1 is a good idea to protect against fragmentation (it causes it); that ASSM has no costs; that tuning consists of getting a good buffer cache hit ratio. You name it, they've touted it.

These days, they have TUSC to do that sort of thing for them.

Regards
HJR

-- 
--------------------------------------------
See my brand new website, soon to be full of 
new articles: www.dizwell.com.
Nothing much there yet, but give it time!!
--------------------------------------------