mssql_indexes.UMLS2018AA.SQL

USE [UMLS2018AA]

/************************************************************************************/
/* Unified Medical Language System - Microsoft SQL Server data load script */
/* Script 3 of 3 */
/* */
/* This script is based upon the "SQL load script for Metathesaurus subset" (Feb 2011) of Dr. Nader Elshehabi, shared
/* on the UMLS website in the UMLS Community - User Contributions section, and upon the */
/* Oracle scripts created during MetamorphoSys execution in the 2018AA release. */
/* https://www.nlm.nih.gov/research/umls/implementation_resources/community/dbloadscripts/metathesaurus_sql.txt */
/* */
/* See the comments of the table creation script for recommended usage */
/************************************************************************************/

/****** CREATE tables indexes ******/

-- WHENEVER SQLERROR EXIT -1
-- SET ECHO ON

-- CREATE INDEX X_MRCONSO_CUI ON MRCONSO(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_CUI')
CREATE NONCLUSTERED INDEX [X_MRCONSO_CUI] ON [dbo].[mrconso]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRCONSO ADD CONSTRAINT X_MRCONSO_PK PRIMARY KEY (AUI)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRCONSO] ADD  CONSTRAINT [X_MRCONSO_PK] PRIMARY KEY CLUSTERED 
(
	[AUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
/*
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'primary key')
CREATE UNIQUE NONCLUSTERED INDEX [primary key] ON [dbo].[mrconso]
(
[AUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
*/

-- CREATE INDEX X_MRCONSO_SUI ON MRCONSO(SUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_SUI')
CREATE NONCLUSTERED INDEX [X_MRCONSO_SUI] ON [dbo].[mrconso]
(
[SUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCONSO_LUI ON MRCONSO(LUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_LUI')
CREATE NONCLUSTERED INDEX [X_MRCONSO_LUI] ON [dbo].[mrconso]
(
[LUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCONSO_CODE ON MRCONSO(CODE)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_CODE')
CREATE NONCLUSTERED INDEX [X_MRCONSO_CODE] ON [dbo].[mrconso]
(
[CODE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCONSO_SAB_TTY ON MRCONSO(SAB,TTY)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_SAB_TTY')
CREATE NONCLUSTERED INDEX [X_MRCONSO_SAB_TTY] ON [dbo].[mrconso]
(
[SAB] ASC,
[TTY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCONSO_SCUI ON MRCONSO(SCUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_SCUI')
CREATE NONCLUSTERED INDEX [X_MRCONSO_SCUI] ON [dbo].[mrconso]
(
[SCUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCONSO_SDUI ON MRCONSO(SDUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_SDUI')
CREATE NONCLUSTERED INDEX [X_MRCONSO_SDUI] ON [dbo].[mrconso]
(
[SDUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCONSO_STR ON MRCONSO(STR)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrconso]') AND name = N'X_MRCONSO_STR')
CREATE NONCLUSTERED INDEX [X_MRCONSO_STR] ON [dbo].[mrconso]
(
[STR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCXT_CUI ON MRCXT(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcxt]') AND name = N'X_MRCXT_CUI')
CREATE NONCLUSTERED INDEX [X_MRCXT_CUI] ON [dbo].[mrcxt]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCXT_AUI ON MRCXT(AUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcxt]') AND name = N'X_MRCXT_AUI')
CREATE NONCLUSTERED INDEX [X_MRCXT_AUI] ON [dbo].[mrcxt]
(
[AUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCXT_SAB ON MRCXT(SAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcxt]') AND name = N'X_MRCXT_SAB')
CREATE NONCLUSTERED INDEX [X_MRCXT_SAB] ON [dbo].[mrcxt]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRDEF_CUI ON MRDEF(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrdef]') AND name = N'X_MRDEF_CUI')
CREATE NONCLUSTERED INDEX [X_MRDEF_CUI] ON [dbo].[mrdef]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRDEF_AUI ON MRDEF(AUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrdef]') AND name = N'X_MRDEF_AUI')
CREATE NONCLUSTERED INDEX [X_MRDEF_AUI] ON [dbo].[mrdef]
(
[AUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRDEF ADD CONSTRAINT X_MRDEF_PK PRIMARY KEY (ATUI)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRDEF] ADD  CONSTRAINT [X_MRDEF_PK] PRIMARY KEY CLUSTERED 
(
	[ATUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
/*
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrdef]') AND name = N'primary key')
CREATE UNIQUE NONCLUSTERED INDEX [primary key] ON [dbo].[mrdef]
(
[ATUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
*/

-- CREATE INDEX X_MRDEF_SAB ON MRDEF(SAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrdef]') AND name = N'X_MRDEF_SAB')
CREATE NONCLUSTERED INDEX [X_MRDEF_SAB] ON [dbo].[mrdef]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIER_CUI ON MRHIER(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrhier]') AND name = N'X_MRHIER_CUI')
CREATE NONCLUSTERED INDEX [X_MRHIER_CUI] ON [dbo].[mrhier]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIER_AUI ON MRHIER(AUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrhier]') AND name = N'X_MRHIER_AUI')
CREATE NONCLUSTERED INDEX [X_MRHIER_AUI] ON [dbo].[mrhier]
(
[AUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIER_SAB ON MRHIER(SAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrhier]') AND name = N'X_MRHIER_SAB')
CREATE NONCLUSTERED INDEX [X_MRHIER_SAB] ON [dbo].[mrhier]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIER_PTR ON MRHIER(PTR)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrhier]') AND name = N'X_MRHIER_PTR')
CREATE NONCLUSTERED INDEX [X_MRHIER_PTR] ON [dbo].[mrhier]
(
[PTR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIER_PAUI ON MRHIER(PAUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrhier]') AND name = N'X_MRHIER_PAUI')
CREATE NONCLUSTERED INDEX [X_MRHIER_PAUI] ON [dbo].[mrhier]
(
[PAUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIST_CUI ON MRHIST(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrhist]') AND name = N'X_MRHIST_CUI')
CREATE NONCLUSTERED INDEX [X_MRHIST_CUI] ON [dbo].[mrhist]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIST_SOURCEUI ON MRHIST(SOURCEUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRHIST]') AND name = N'X_MRHIST_SOURCEUI')
CREATE NONCLUSTERED INDEX [X_MRHIST_SOURCEUI] ON [dbo].[MRHIST]
(
[SOURCEUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRHIST_SAB ON MRHIST(SAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRHIST]') AND name = N'X_MRHIST_SAB')
CREATE NONCLUSTERED INDEX [X_MRHIST_SAB] ON [dbo].[MRHIST]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRRANK ADD CONSTRAINT X_MRRANK_PK PRIMARY KEY (SAB,TTY)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRRANK] ADD  CONSTRAINT [X_MRRANK_PK] PRIMARY KEY CLUSTERED 
(
	[SAB,TTY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRREL_CUI1 ON MRREL(CUI1)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRREL]') AND name = N'X_MRREL_CUI1')
CREATE NONCLUSTERED INDEX [X_MRREL_CUI1] ON [dbo].[MRREL]
(
[CUI1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRREL_AUI1 ON MRREL(AUI1)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRREL]') AND name = N'X_MRREL_AUI1')
CREATE NONCLUSTERED INDEX [X_MRREL_AUI1] ON [dbo].[MRREL]
(
[AUI1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRREL_CUI2 ON MRREL(CUI2)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRREL]') AND name = N'X_MRREL_CUI2')
CREATE NONCLUSTERED INDEX [X_MRREL_CUI2] ON [dbo].[MRREL]
(
[CUI2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRREL_AUI2 ON MRREL(AUI2)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRREL]') AND name = N'X_MRREL_AUI2')
CREATE NONCLUSTERED INDEX [X_MRREL_AUI2] ON [dbo].[MRREL]
(
[AUI2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRREL ADD CONSTRAINT X_MRREL_PK PRIMARY KEY (RUI)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRREL] ADD  CONSTRAINT [X_MRREL_PK] PRIMARY KEY CLUSTERED 
(
	[RUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRREL_SAB ON MRREL(SAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRREL]') AND name = N'X_MRREL_SAB')
CREATE NONCLUSTERED INDEX [X_MRREL_SAB] ON [dbo].[MRREL]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRSAB ADD CONSTRAINT X_MRSAB_PK PRIMARY KEY (VSAB)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRSAB] ADD  CONSTRAINT [X_MRSAB_PK] PRIMARY KEY CLUSTERED 
(
	[VSAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSAB_RSAB ON MRSAB(RSAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSAB]') AND name = N'X_MRSAB_RSAB')
CREATE NONCLUSTERED INDEX [X_MRSAB_RSAB] ON [dbo].[MRSAB]
(
[RSAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSAT_CUI ON MRSAT(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSAT]') AND name = N'X_MRSAT_CUI')
CREATE NONCLUSTERED INDEX [X_MRSAT_CUI] ON [dbo].[MRSAT]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSAT_METAUI ON MRSAT(METAUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSAT]') AND name = N'X_MRSAT_METAUI')
CREATE NONCLUSTERED INDEX [X_MRSAT_METAUI] ON [dbo].[MRSAT]
(
[METAUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRSAT ADD CONSTRAINT X_MRSAT_PK PRIMARY KEY (ATUI)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRSAT] ADD  CONSTRAINT [X_MRSAT_PK] PRIMARY KEY CLUSTERED 
(
	[ATUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSAT_SAB ON MRSAT(SAB)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSAT]') AND name = N'X_MRSAT_SAB')
CREATE NONCLUSTERED INDEX [X_MRSAT_SAB] ON [dbo].[MRSAT]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSAT_ATN ON MRSAT(ATN)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSAT]') AND name = N'X_MRSAT_ATN')
CREATE NONCLUSTERED INDEX [X_MRSAT_ATN] ON [dbo].[MRSAT]
(
[ATN] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSTY_CUI ON MRSTY(CUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSTY]') AND name = N'X_MRSTY_CUI')
CREATE NONCLUSTERED INDEX [X_MRSTY_CUI] ON [dbo].[MRSTY]
(
[CUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- ALTER TABLE MRSTY ADD CONSTRAINT X_MRSTY_PK PRIMARY KEY (ATUI)
-- USING INDEX PCTFREE 10 COMPUTE STATISTICS;
ALTER TABLE [dbo].[MRSTY] ADD  CONSTRAINT [X_MRSTY_PK] PRIMARY KEY CLUSTERED 
(
	[ATUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRSTY_STY ON MRSTY(STY)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRSTY]') AND name = N'X_MRSTY_STY')
CREATE NONCLUSTERED INDEX [X_MRSTY_STY] ON [dbo].[MRSTY]
(
[STY] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXNS_ENG_NSTR ON MRXNS_ENG(NSTR)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXNS_ENG]') AND name = N'X_MRXNS_ENG_NSTR')
CREATE NONCLUSTERED INDEX [X_MRXNS_ENG_NSTR] ON [dbo].[MRXNS_ENG]
(
[NSTR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXNW_ENG_NWD ON MRXNW_ENG(NWD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXNW_ENG]') AND name = N'X_MRXNW_ENG_NWD')
CREATE NONCLUSTERED INDEX [X_MRXNW_ENG_NWD] ON [dbo].[MRXNW_ENG]
(
[NWD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_BAQ_WD ON MRXW_BAQ(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_BAQ]') AND name = N'X_MRXW_BAQ_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_BAQ_WD] ON [dbo].[MRXW_BAQ]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_CHI_WD ON MRXW_CHI(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_CHI]') AND name = N'X_MRXW_CHI_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_CHI_WD] ON [dbo].[MRXW_CHI]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_CZE_WD ON MRXW_CZE(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_CZE]') AND name = N'X_MRXW_CZE_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_CZE_WD] ON [dbo].[MRXW_CZE]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_DAN_WD ON MRXW_DAN(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_DAN]') AND name = N'X_MRXW_DAN_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_DAN_WD] ON [dbo].[MRXW_DAN]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_DUT_WD ON MRXW_DUT(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_DUT]') AND name = N'X_MRXW_DUT_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_DUT_WD] ON [dbo].[MRXW_DUT]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_ENG_WD ON MRXW_ENG(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_ENG]') AND name = N'X_MRXW_ENG_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_ENG_WD] ON [dbo].[MRXW_ENG]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_EST_WD ON MRXW_EST(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_EST]') AND name = N'X_MRXW_EST_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_EST_WD] ON [dbo].[MRXW_EST]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_FIN_WD ON MRXW_FIN(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_FIN]') AND name = N'X_MRXW_FIN_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_FIN_WD] ON [dbo].[MRXW_FIN]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_FRE_WD ON MRXW_FRE(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_FRE]') AND name = N'X_MRXW_FRE_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_FRE_WD] ON [dbo].[MRXW_FRE]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_GER_WD ON MRXW_GER(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_GER]') AND name = N'X_MRXW_GER_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_GER_WD] ON [dbo].[MRXW_GER]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_GRE_WD ON MRXW_GRE(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_GRE]') AND name = N'X_MRXW_GRE_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_GRE_WD] ON [dbo].[MRXW_GRE]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_HEB_WD ON MRXW_HEB(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_HEB]') AND name = N'X_MRXW_HEB_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_HEB_WD] ON [dbo].[MRXW_HEB]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_HUN_WD ON MRXW_HUN(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_HUN]') AND name = N'X_MRXW_HUN_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_HUN_WD] ON [dbo].[MRXW_HUN]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_ITA_WD ON MRXW_ITA(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_ITA]') AND name = N'X_MRXW_ITA_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_ITA_WD] ON [dbo].[MRXW_ITA]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_JPN_WD ON MRXW_JPN(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_JPN]') AND name = N'X_MRXW_JPN_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_JPN_WD] ON [dbo].[MRXW_JPN]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_KOR_WD ON MRXW_KOR(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_KOR]') AND name = N'X_MRXW_KOR_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_KOR_WD] ON [dbo].[MRXW_KOR]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_LAV_WD ON MRXW_LAV(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_LAV]') AND name = N'X_MRXW_LAV_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_LAV_WD] ON [dbo].[MRXW_LAV]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_NOR_WD ON MRXW_NOR(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_NOR]') AND name = N'X_MRXW_NOR_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_NOR_WD] ON [dbo].[MRXW_NOR]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_POL_WD ON MRXW_POL(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_POL]') AND name = N'X_MRXW_POL_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_POL_WD] ON [dbo].[MRXW_POL]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_POR_WD ON MRXW_POR(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_POR]') AND name = N'X_MRXW_POR_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_POR_WD] ON [dbo].[MRXW_POR]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_RUS_WD ON MRXW_RUS(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_RUS]') AND name = N'X_MRXW_RUS_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_RUS_WD] ON [dbo].[MRXW_RUS]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_SCR_WD ON MRXW_SCR(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_SCR]') AND name = N'X_MRXW_SCR_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_SCR_WD] ON [dbo].[MRXW_SCR]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_SPA_WD ON MRXW_SPA(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_SPA]') AND name = N'X_MRXW_SPA_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_SPA_WD] ON [dbo].[MRXW_SPA]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_SWE_WD ON MRXW_SWE(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_SWE]') AND name = N'X_MRXW_SWE_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_SWE_WD] ON [dbo].[MRXW_SWE]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRXW_TUR_WD ON MRXW_TUR(WD)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRXW_TUR]') AND name = N'X_MRXW_TUR_WD')
CREATE NONCLUSTERED INDEX [X_MRXW_TUR_WD] ON [dbo].[MRXW_TUR]
(
[WD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_AMBIGSUI_SUI ON AMBIGSUI(SUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AMBIGSUI]') AND name = N'X_AMBIGSUI_SUI')
CREATE NONCLUSTERED INDEX [X_AMBIGSUI_SUI] ON [dbo].[AMBIGSUI]
(
[SUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_AMBIGLUI_LUI ON AMBIGLUI(LUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AMBIGLUI]') AND name = N'X_AMBIGLUI_LUI')
CREATE NONCLUSTERED INDEX [X_AMBIGLUI_LUI] ON [dbo].[AMBIGLUI]
(
[LUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRAUI_CUI2 ON MRAUI(CUI2)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRAUI]') AND name = N'X_MRAUI_CUI2')
CREATE NONCLUSTERED INDEX [X_MRAUI_CUI2] ON [dbo].[MRAUI]
(
[CUI2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRCUI_CUI2 ON MRCUI(CUI2)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRCUI]') AND name = N'X_MRCUI_CUI2')
CREATE NONCLUSTERED INDEX [X_MRCUI_CUI2] ON [dbo].[MRCUI]
(
[CUI2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

-- CREATE INDEX X_MRMAP_MAPSETCUI ON MRMAP(MAPSETCUI)
-- PCTFREE 10 COMPUTE STATISTICS;
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[MRMAP]') AND name = N'X_MRMAP_MAPSETCUI')
CREATE NONCLUSTERED INDEX [X_MRMAP_MAPSETCUI] ON [dbo].[MRMAP]
(
[MAPSETCUI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

/* MRCOC not covered by oracle_indexes.sql created by MetaMorphosys for my Hopkins subset.
   These remaining indexes were from Dr. Elshehabi's scripts from 2011.

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcoc]') AND name = N'X_MRCOC_AUI1')
CREATE NONCLUSTERED INDEX [X_MRCOC_AUI1] ON [dbo].[mrcoc]
(
[AUI1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcoc]') AND name = N'X_MRCOC_AUI2')
CREATE NONCLUSTERED INDEX [X_MRCOC_AUI2] ON [dbo].[mrcoc]
(
[AUI2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcoc]') AND name = N'X_MRCOC_CUI1')
CREATE NONCLUSTERED INDEX [X_MRCOC_CUI1] ON [dbo].[mrcoc]
(
[CUI1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcoc]') AND name = N'X_MRCOC_CUI2')
CREATE NONCLUSTERED INDEX [X_MRCOC_CUI2] ON [dbo].[mrcoc]
(
[CUI2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[mrcoc]') AND name = N'X_MRCOC_SAB')
CREATE NONCLUSTERED INDEX [X_MRCOC_SAB] ON [dbo].[mrcoc]
(
[SAB] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
*/

PRINT('Done creating indexes.');