FAQ: Should I Separate Indexes and Tables into Different Tablespaces for Performance?

Answer

No. There are no performance gains when placing the indexes and tables into different tablespaces. However, there are arguments to separate indexes from tables for management reasons.

Note:
Refer to the related information section for links to Oracle discussions regarding tablespace management.

Article ID: 000006722

Software:

Legacy Products

Related Information

Ask Tom - How to separate an index table from data tablespace
HowTo Stop Defragmenting and Start Living: The Definitive Word on Fragmentation
Optimal Storage Configuration Made Easy
Configuring the Oracle Database with VERITAS Software

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Should I separate indexes and tables into different tablespaces for performance?

Answer

Receive notifications and find solutions for new or common issues

Related Information

Discover more on this topic