Re: Myth revisited ...

Comments in-line

Hans Forbrich wrote:

> At the risk of being shot, drawn and quartered:

Make that sliced and diced. Quartered is too generous.

> I know (and agree with) the fundemental discussion that separating
> indexes and tables into separate tablespaces should not be done for
> performance reasons - in pre-Oracle9i environments!
>
> However, with Oracle9i and it's support for multiple block sizes: Is
> there a possible performance benefit to be obtained by placing the
> tables and [some] indexes in separate tablespaces, IF the tablespaces
> have different blocksizes?

Well those that approach this with religious zeal will likely weight in but I suspect we should all suspend judgement until Jonathan, Richard, or someone else with more time than I have actually benchmarks it.

I have to confess it is something I've not contemplated and I can, at least in theory, see some possibilities. Hmmmm.

> (If this has been previously discussed, please just point me to the
> approximate time frame so I can review the archives.)
>
> /Hans

I think you've stirred up some brand new trouble not previously added to the stew. I like it. A little salt, pepper, and a Bay leaf and I might like it even better.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)