Article Content
Article Number | 000030788 |
Applies To | RSA Product Set: RSA Archer RSA Product/Service Type: Data Feeds RSA Versions: All |
Issue | Slow Text Keyed Data Feeds. |
Tasks | 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. |
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 |