Page History
HTML |
---|
<style> .release-box { height: 30px; width: 100px; padding-top: 8px; text-align: center; border-radius: 5px; font-weight: bold; background-color: #DDA0DD; border-color: #FCE28A; } .release-box:hover { cursor: hand; cursor: pointer; opacity: .9; } </style> <meta name="robots" content="noindex"> <div class="release-box"> <a href="https://docs.perspectium.com/display/Helium" style="text-decoration: none; color: #FFFFFF; display: block;"> Helium </a> </div> |
Database indexing is used to speed up data retrieval when querying for records from database tables. Enabling the Share Index option allows you to share the indexes of a table in ServiceNow through a bulk share so the same indexes can be created in the database where you've shared data to.
With this option enabled, the bulk share shares out an index message that contains the columns that are indexed in the table as its configured in ServiceNow. The DataSync Agent will then pick up this message and create indexes on the columns of the database table to match.
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:
UI Steps | ||||||||
---|---|---|---|---|---|---|---|---|
|
Similar topics
Content by Label showLabels false max 5 showSpace false sort modified cql label = "datasync-agent" and space = currentSpace()