Merging tablespace index into tablespace data table

SunilKarde1 — Thu, 19 Oct 2023 22:04:11 GMT

Can we safely merge tablespace index into tablespace data or is there any impact if we combine tablespace index into tablespace data when designing oracle enterprise geodatabase.

Re: Merging tablespace index into tablespace data table

MarceloMarques — Thu, 19 Oct 2023 22:04:59 GMT

@SunilKarde1 - the best practice is to separate tables and indexes to reduce fragmentation and contention and to improve performance. I do not recommend placing tables and indexes on the same tablespace. You will need to rebuild indexes often as your data changes overtime (inserts, updates, deletes), having the indexes in a different tablespace improves performance to rebuild indexes, gather new statistics, reduces contention and fragmentation of the tablespace datafiles. If you want to learn more about this then see the link below, read my database guide book for Oracle, the Production Mapping is generic and can be applied to any industry. You can also find there my database template scripts with detail on how to setup the Oracle Enterprise Geodatabase for production.
Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices
I hope this clarifies your question.

topic Merging tablespace index into tablespace data table in Geodatabase Questions

Merging tablespace index into tablespace data table

Re: Merging tablespace index into tablespace data table