English

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

Question

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.

Related Information