Data Feed Performance Improvement using a SQL Text Index in RSA Archer
RSA Product Set: RSA Archer RSA Product/Service Type: Data Feeds RSA Versions: All
Slow Text Keyed Data Feeds.
There 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.
/****** 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