Myth revisited ...

At the risk of being shot, drawn and quartered:

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?

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

/Hans Received on Sat Nov 15 2003 - 20:33:58 CST