Use this utility to identify the database tablespace (Oracle) or filegroup (SQL Server) to use when creating dynamic temporary tables in some of the reports, processes, and postings. A tablespace/filegroup must already exist in the database before specifying it here.
If there are no entries on this screen, dynamic tables and indexes will use the default settings established by the database vendor.
If a tablespace/filegroup is specified for a given dynamic table or index, Costpoint will use that specified tablespace/filegroup.
For all other dynamic tables or indexes not specified in this table, Costpoint will use the first tablespace/filegroup it finds in this table. This will significantly reduce data entry on this screen for customers who want to use the same tablespace/filegroup for all dynamic tables and indexes. (Only one dynamic table and one dynamic index is required on this screen.)
For more information on dynamic temporary tables, see Application Locking/Dynamic Tables, and refer to the manuals provided by your database vendor for details about the tablespace/filegroup of your database.
The tablespace/filegroup is used every time the object (that is, the dynamic table and/or index) is created because they become part of the Create Table SQL command.
Use this field to enter the name of the dynamic table or index that is to be fine-tuned.
Use this field to enter T if the object is a table or I if the object is an index.
Use this field to enter the segment to which this object is assigned.
Your database administrator must use this function whenever there is a need to fine-tune the database.