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

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000030788
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Data Feeds
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 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