We highly recommend creating indexes within Eclipse. By doing this, you ensure that if a file version changed or the customer elected to re-sync a file regardless of the reason, those indexes are not deleted and you do not have to manually recreate the indexes in the SQL environment. This setup makes ongoing support and maintenance easier.
To add an index in Eclipse:
From the System > Custom > Add On Products > SQL menu, select SQL Server Database Maintenance.
Place the cursor on the table you want to add an index to as instructed from SQL Server Management Studio
Use the Expand hot key to display SQL Server Table Maintenance screen.
Use the Indexes hot key and select New from the list.
Populate the following columns for the index you want to add.
Column |
Description |
Key Columns |
Indicate which columns are Key Columns noted just to the right of the table name in SQL Server Management Studio. |
Sort Order |
Indicate which order you want to sort by: ascending or descending. |
SQL Type |
Defaults based on the SQL type of data for the table columns selected |
Use the Included columns to add other table columns in the Index as directed by SQL Server Management Studio.
Use the Create Index hot key and type Yes at prompt to confirm that you want to create the index
The Create Index command is added to the SQL Replication queue and is sent over to SQL when the next sync occurs. This could be a while if heavy replication is occurring at the same time, so the system holds the information until the next sync. The table does not need to be re-synced to activate the new index.
You can confirm the index was created by viewing it from within SQL Server Management Studio by navigating in the left-hand, file tree, to the database, the table, and expanding the Indexes folder for that table. Re-executing the cleansed SQL command of your BAQ in SSMS with the indexes in place provides a revised completion time expectation.