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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic: Help with general preformance increase...
Next Topic: Performance tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 18:06:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.