Home » RDBMS Server » Server Administration » Do Indexes and table data have to be in separate tbsp
Do Indexes and table data have to be in separate tbsp [message #203319] Tue, 14 November 2006 15:19 Go to next message
aidi-h
Messages: 44
Registered: November 2005
Member
I have been asked a query and would like a definitive answer if possible.
When creating an Oracle DB, do the indexes and Table data have to be in separate tablespaces?
From what I have read, performance is not improved if they are in different tbsp unless possibly if they sit on different disks and that the only benefit these days may be management of data. Is this the case?
What is the position of Oracle on this matter?
Any help would be appreciated.
Re: Do Indexes and table data have to be in separate tbsp [message #203335 is a reply to message #203319] Tue, 14 November 2006 16:37 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
look no further...
http://www.dizwell.com/dokuwiki/doku.php?id=separatetablesandindexes
Previous Topic: Looking for some sample script
Next Topic: OEM issues on a system which having software only(Oracle 10g rel2)
Goto Forum:
  


Current Time: Sat Dec 10 16:56:32 CST 2016

Total time taken to generate the page: 0.11097 seconds