Keep XML and relational data in separate table spaces


XML data is usually larger in size compared to relational data and indexes. Data buffering and caching will be more effective hence better performance if XML data uses larger page sized table space and buffer pool. To do so, you simply assign the XML and relational data to different table space at table creation time. The example on the right pane demonstrated the steps required.

Operations



Note that the CREATE TABLESPACE statements may fail if they already exist in the database. If that's the case, you may ignore those errors.