Database indexing are used to speed up data retrieval. Enabling the Share Index option allows you to share the indexes of a table in ServiceNow through a bulk share. The bulk share then shares out an index message that contains the columns that will be indexed in the database table.
With DataSync Agent, the messages created by the bulk share will send over to your database and will create indexes on the columns of the database table that was shared to.
NOTE: Indexing database tables is compatible with Oracle, SQL Server, and MySQL databases, and is only used for DataSync. Snowflake does not support indexing, therefore, this feature is not compatible for Snowflake.
Procedure
To share indexed tables from ServiceNow to a database through the DataSync Agent, follow these steps:
Create a table index
Log into your ServiceNow instance. Then, follow the steps in this link on creating table indexes.
Navigate to Bulk Share
In ServiceNow's left side navigation window, navigate to Perspectium > Replicator > Bulk Share or simply type and then click on Bulk Share. Then, click New to create a new bulk share.
Access advance options
Check Advanced. Once that option is checked, an Advanced tab will appear with the rest of the selection tabs.
Enable Share Index.
Check Share Index. Then, follow the rest of the steps in Create a ServiceNow bulk share.
Click the Save button at the bottom of the form to save the configurations for your bulk share. Once your bulk share configurations have been saved, you can click back into the bulk share record and click the Execute Now button at the bottom of the form to bulk share out the specified records immediately.
Upon execution of the bulk share, you should see that an index message has been shared out in addition to the other records.
Once the index message is received by the DataSync Agent, it will create indexes on the columns of the database table that was shared to.
NOTE: The index message will only be shared out once per bulk share.
