|
From: Haiming W. <hw...@ug...> - 2005-06-28 13:32:44
|
According to the Optimal Flexible Architecture (OFA) standard for Oracle , it would be a best practice for having separate indexes from the data. Create your primary key and all other indexes in a separate tablespace and put that on a separate disk and controller. Thanks for adding this support in the next GUS release. -Haiming On Tue, 2005-06-28 at 09:09, Michael Saffitz wrote: > > 1) 3.0 has separate tablespaces for each name space and its index. Do > > you want to keep those tablespaces or merge them into one? > > We anticipate that most installations of GUS really only need one > tablespace, since data storage parameters are likely to be the same for all > GUS tables. This being said, I could foresee someone wanting to run > standard tables in archivelog mode, and version tables in noarchivelog mode. > One of my to do items for the next release is to better support the multiple > tablespaces. |