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

Jack wrote:

>
> Look:
> http://otn.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
>
> You might have a look at Juan Loaiza's article "Optimal Storage
> Configuration Made Easy" http://technet.oracle.com/deploy/performance/ for
> a
> different approach to the problem. Since this is on technet, it appears
> to be Oracle's latest recommendation.

Sorry Jack: you're wrong on this, though I suppose it depends on what you mean by 'recommendation'.

Of course there are papers about RAID and SANE on their website. I'm not disputing that. I'm not even disputing that RAID and SANE are jolly good ideas and should be implemented wherever possible,

But what I am saying is that as of last week, their own Performance Tuning course notes and their own DBA Fundamentals course notes state, in black and white, to separate indexes from tables, and that performance benefits will arise as a result.

We may agree to differ on what constitutes a recommendation, but as far as I'm concerned, what they tell their instructors to teach to fee-paying students is much more of an 'official' point of view than what freebie pdfs they might have hanging around on their website.

That's all I'm saying. And all what the original poster was saying.

Though I will go one step further, though it's only a logical conclusion from what's already been discussed: one should be very careful about making statements about what Oracle recommends or what its 'position' on something is. Because the right hand quite frequently doesn't agree with what the left hand has been writing.

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!!
--------------------------------------------