Home » RDBMS Server » Performance Tuning » Indexes on LMT
icon5.gif  Indexes on LMT [message #259860] Thu, 16 August 2007 13:15 Go to next message
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 #259863 is a reply to message #259860] Thu, 16 August 2007 13:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All these points are true.

Regards
Michel
Re: Indexes on LMT [message #259875 is a reply to message #259863] Thu, 16 August 2007 13:40 Go to previous messageGo to next message
sudipsarkar
Messages: 2
Registered: August 2007
Junior Member
Great! thanks a lot
Re: Indexes on LMT [message #259945 is a reply to message #259875] Thu, 16 August 2007 21:59 Go to previous message
rleishman
Messages: 3724
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
Previous Topic: How to recreate statistics to whole schema?
Next Topic: Some missing concepts and definitions
Goto Forum:
  


Current Time: Sat Dec 03 12:20:13 CST 2016

Total time taken to generate the page: 0.07625 seconds