|
Re: index & tables should be separated? [message #214831 is a reply to message #214826] |
Thu, 18 January 2007 04:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
For a certain administrative reasons yes (like a seperate backup window).
For performance reasons no. It makes no difference whether you keep tables and indexes in same tables or different tablespace.
What matters is , you need distribute the i/o into seperate DISKS. Not just tablespaces. Morever Oracle will access it in serial only.
FIrst index and then data.
[Updated on: Thu, 18 January 2007 04:28] Report message to a moderator
|
|
|
|