000030788 - Data Feed Performance Improvement using a SQL Text Index in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 9, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030788
Applies ToRSA Product Set: RSA Archer
RSA Product/Service Type: Data Feeds
RSA Versions: All
IssueSlow Text Keyed Data Feeds.
TasksThere is a disk space consideration when it comes to this index because it includes all the text fields as part of the index so it should only be used for Data Feeds that have text values as keys and a desire to improve the performance of data feeds. In some cases, this index has improved queries taking 250-500ms down to 15-75ms.
Resolution
/****** Object:  Index [IX_tblIVTextData_checksum_value_field_id]   ******/
CREATE NONCLUSTERED INDEX [IX_tblIVTextData_checksum_value_field_id] ON [dbo].[tblIVTextData]
(
                [checksum_value] ASC,
                [field_id] ASC
)
INCLUDE ( [field_value]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 95) ON [PRIMARY]
GO

 

Attachments

    Outcomes