Automate Rebuilding the SQL Indexes

Issue No: FRM-7507
Created 7/3/2018 6:59:36 PM
Type Feature
Priority Minor
Status Closed
Resolution Fixed
Fixed Version 18.3
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-258717 - Re-Indexing Script|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-258717]   Automate reindexing the SQL Server Indexes using a stored procedure. Here is an example. [https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/database-maintenance-plan-stored-procedures-transact-sql?view=sql-server-2017]   Create a custom SP that executes whenever we install a new build. Build a script and add it to the SQL Script Project so it can be executed whenever there’s a build.