Originally posted by slimdave
I don't believe there to be any performance of maintenance banefit from separating indexes and tables into different tablespaces -- look at asktom.oracle.com or the google forums for many discussions on this.
I've been following advice and putting objects in tablespaces based purely on their size for quite a while now, and it works great. Maybe a dedicated TS for a particular table
If you see no benefit to seperating the index and table, then why are you splitting tables into different tablespaces... managability?
Hmmm...
What I can gather there is no performance advantage of seperation, just a managability issue.
These may help..
http://asktom.oracle.com/pls/ask/f?p...1463404632043,
http://groups.google.com/groups?dq=&...40news.free.fr
Last edited by grjohnson; 12-09-2002 at 01:49 AM.
OCP 8i, 9i DBA
Brisbane Australia
Reply With Quote