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.