Add a Search Index for when Records were Created - Precisely_EnterWorks - EnterWorks - 11.0

The B_MASTER_REPOSITORY_ITEM table contains all the repository records in the EPIM database. The table has several indexes that improve system performance. But if your repositories have thousands of records and you perform a lot of searches based on the date and time a record was created, adding an index on the B_MASTER_REPOSITORY_ITEM table's CREATION_DATETIME column may improve your search times. Note that each index you have on a table takes processing time to maintain, so you will have to evaluate whether or not it makes sense for you to add this index to your system.

To add an index for record creation datetimes:

1. Open the following file in an editor:

   <drive>:\Enterworks\EnableServer\DBUpgrade\EPIM_OptionalSQL.sql

2. If you are not already logged into SSMS on the source environment, log in now as a user with administrator permissions.
3. Open a new query on the EPIM database.
4. Copy the script from the file:

   <drive>:\Enterworks\EnableServer\DBUpgrade\EPIM_OptionalSQL.sql

   to the query window.
5. Run the query.