Create index files for the VVCMODEL.VERSION table Back to top

The VVCMODEL.VERSION table is not indexed by the upgrade procedure. After you upgrade your server, you must run the following commands to create index files for the VVCMODEL.VERSION table.

1. Open a sqlcmd command line tool and enter the following commands:

   ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(450) NOT NULL
   ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(450) NULL

   CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)
   CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)

This appeared in our interactive guide. We don't use Global Configuration, is this mandatory? This is not listed as Optional.