Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Index on cMass ttRequestRoleValidation table for performance.

Please consider creating following indexes: 
 
Number of Records Validated: ~300
Time to validate before indexes: > 3 minutes and network error on application.
Time to validate after indexes: < 30 seconds.
 
--CREATE INDEX IDX_ttRequestRoleValidation_RequestID
--ON [cMass].[dbo].[ttRequestRoleValidation]
--( [RequestID])
--INCLUDE( [RequestRoleValidationID],
--[RoleID])

--CREATE INDEX IDX_ttRequestRoleValidation_RequestID_RoleID
--ON [cMass].[dbo].[ttRequestRoleValidation]
--( [RequestID], [RoleID])
--INCLUDE ([PageID])
 
 
  • Prasad Wadekar
  • Sep 7 2017
  • Unlikely to Implement
Data Quality (SST)
  • Feb 7, 2019

    Admin response

    This has been investigated by engineering and cannot be reproduced internally.  We will move this ticket back into backlog to wait for additional information from other clients.

  • Attach files

Related ideas