Home » RDBMS Server » Performance Tuning » index & tables should be separated?
index & tables should be separated? [message #214826] Thu, 18 January 2007 04:14 Go to next message
karismapanda
Messages: 58
Registered: January 2007
Member
should we keep indexes and tables in different tablespaces
Re: index & tables should be separated? [message #214831 is a reply to message #214826] Thu, 18 January 2007 04:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

thanks [message #214852 is a reply to message #214831] Thu, 18 January 2007 04:47 Go to previous message
karismapanda
Messages: 58
Registered: January 2007
Member
thanks
Previous Topic: Help with general preformance increase...
Next Topic: Performance tuning
Goto Forum:
  


Current Time: Fri Dec 02 19:00:41 CST 2016

Total time taken to generate the page: 0.26054 seconds