CREATE INDEX X_MRCONSO_CUI ON MRCONSO(CUI)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRCONSO_SUI ON MRCONSO(SUI)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRCONSO_LUI ON MRCONSO(LUI)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRCONSO_CODE ON MRCONSO(CODE)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRCONSO_SAB_TTY ON MRCONSO(SAB,TTY)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRSTY_CUI ON MRSTY(CUI)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRSTY_STY ON MRSTY(STY)
PCTFREE 10 COMPUTE STATISTICS;

CREATE INDEX X_MRSTY_CUITUI ON MRSTY(CUI, TUI)
PCTFREE 10 COMPUTE STATISTICS;
