Skip to end of metadata
Go to start of metadata

SQL Indexes

An index can be created in a table to find data more quickly and efficiently via SQL Management studio or via SQL Script.

The users cannot see the indexes, they are just used to speed up searches and queries.

Updating a table with indexes takes more time than updating a table without indexes (because indexes also need an update). Indexes should only be created on database objects that will be frequently searched against.

SQL Tables with Indexes In GlobalSearch's Database

Each table has at least one index on it. Some have more then one, and are listed below:

WARNING

Always take a backup before performing any SQL operations.  Failure to take a proper backup may result in permanent data loss.


Table NameIndex NameKey ColumnsSort OrderIncluded Columns
ssArchive[id]IX_SSArchive[ID]_DocIDDocIDDescendingFilePath, FileType
ssArchiveWorkflowsisSystemWorkflowisSystemWorkflow,ArchiveIDAscending,Ascending
ssDataXChangeMappingIX_ssDataXCMapping_SourceIDSourceIDAscending
ssDataXChangeSourceIX_ssDataXCSource_ArchiveIDArchiveID,SourceNameAscending,Ascending
ssFieldsIX_ssFields_ArchiveID_DocIDArchiveID,DocIDAscending,DescendingAll Other Columns
ssMVFieldsIX_ssMVFields_ArchiveID_DocIDArchiveID,DocIDAscending,Descending
ssWFCheckCriteriaCheckIDCheckIDAscending
ssWFCheckPointsWorkflowIDWorkflowIDAscending
ssWFCriteriaWorkflowIDWorkflowIDAscending
ssWFQueueArchiveIDArchiveIDAscending