Summary Table
Categories |
Total Count |
PII |
0 |
URL |
0 |
DNS |
0 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
?-- =============================================
-- Description: drops NCI indexes for IDs on Raw tables Post load to cores
--
-- Maintenance Log:
--
-- Update By Update Date Description
-- --------- ----------------------------
-- =============================================
CREATE PROCEDURE zraw.[uspDoDropRawConsultIndexesPostCoreLoad]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
BEGIN TRY
--non clustered
--BatchLogID
DROP INDEX zraw._conConsult.IX_conConsult_BatchLogID;
--StatusTypeID
DROP INDEX zraw._conConsult.IX_conConsult_StatusTypeID;
--RequestServiceID
DROP INDEX zraw._conConsult.IX_conConsult_RequestServiceID;
--StationID
DROP INDEX zraw._conConsult.IX_conConsult_StationID;
--OneConsultID
DROP INDEX zraw._conConsult.IX_conConsult_OneConsultID;
END TRY
BEGIN CATCH
PRINT 'There was an error dropping NCI IDs post Load to core tables' + CHAR(13)
SELECT * FROM dbo.ufnGetErrorInfo()
EXEC dbo.uspRaiseErrorInfo
END CATCH
END