 Indexes on LMT [message #259860] |
Thu, 16 August 2007 13:15  |
sudipsarkar
Messages: 2
Registered: August 2007
|
Junior Member |
|
|
Hi All,
My DBA says that our Database is on a SAN, the need for separation of data and index is no longer
required from a hardware perspective.
And, with locally managed tablespaces with automatic extent sizing and automatic segment space
management, fragmentation is supposed to be a thing of the past. "
Is this true that we dont need to create a separate tablespaces for Indexes anymore?
We are using 10g on Solaris.
Thanks and Regards
Sudip
|
|
|
|
|
|
|
|
| Re: Indexes on LMT [message #259945 is a reply to message #259875] |
Thu, 16 August 2007 21:59  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
On a very large DB, you may want to backup table tablespaces more often than index tablespaces to save time.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
