Setting parameters in the storage parameter file

Note: The storage parameter file is scanned from the beginning whenever a CREATE TABLE or CREATE INDEX is performed. The first entry that matches the table or index is taken, therefore the order in which the entries are specified is important.

This is an example of a storage parameter file:

ttadv999,ttadv000:000:T:FILEGROUP mydatafilegroup 
ttadv999,ttadv000:000:I:FILEGROUP myindexfilegroup
*:*:T:011:FILEGROUP mydatafilegroup 
*:*:I:FILEGROUP myindexfilegroup

In the storage parameter file example, the tables ttadv999 and ttadv000 of company 000 are created in the file group mydatafilegroup. The associated indexes, except index 1, is created in file group myindexfilegroup and index 1 is a clustered index. All other tables and indexes are created in the default file group.

Note: If the file group for a table or index is not specified, the table and index data are created in the default (usually primary) file group. If you want to physically separate the index data, you must specify a different file group.