OraFAQ Forum: Server Administration » Do Indexes and table data have to be in separate tbsp

Home » RDBMS Server » Server Administration » Do Indexes and table data have to be in separate tbsp

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Do Indexes and table data have to be in separate tbsp [message #203319]

Tue, 14 November 2006 15:19

aidi-h
Messages: 45
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.

Report message to a moderator

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

andrew again
Messages: 2577
Registered: March 2000

Senior Member

look no further...
http://www.dizwell.com/dokuwiki/doku.php?id=separatetablesandindexes

Report message to a moderator

Previous Topic:	Looking for some sample script
Next Topic:	OEM issues on a system which having software only(Oracle 10g rel2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 19 22:33:22 CDT 2026