Defining Multiple Index Locations

Use this procedure to define multiple index locations for all indexes on a table.

To define multiple index locations

  1. Start the SQL utility.
  2. Make changes to law_dba_index by issuing SQL statements:

    insert into law_dba_index (table_name, index_name, fill_factor, filegroup_name, cluster)

    values ('file_name', 'index_name', null, 'newfilegroup', null)

    go

  3. Drop and rebuild the index using the new definition. At the command prompt, type:

    bldmsf2000ddl -URI dataarea [systemcode [filename]]