/
githubmirror
/
cmssw
Обзор
Документация
Войти
/
githubmirror
/
cmssw
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
OnlineDB/EcalCondDB/sql/create_laser_new.sql
598 строк
14 KB
Giulio Eulisse
Snapshot of CMSSW_6_2_0_pre8.
26 июн 2013, 18:12
26 июн 2013, 18:12
214ab73
Код
Авторство
О чём код?
/* * * GO 20091112: indexes added * */ CREATE SEQUENCE lmf_run_tag_sq INCREMENT BY 1 START WITH 1 NOCACHE; CREATE SEQUENCE lmf_run_iov_sq INCREMENT BY 1 START WITH 1 NOCACHE; /* LMF_RUN_TAG */ CREATE TABLE LMF_RUN_TAG ( GEN_TAG VARCHAR2(100), VERSION NUMBER(4), TAG_ID NUMBER NOT NULL ) / ALTER TABLE LMF_RUN_TAG ADD CONSTRAINT LMF_RUN_TAG_PK PRIMARY KEY (TAG_ID) / CREATE TABLE LMF_LASER_COLORS_DEF ( LMF_COLOR_ID NUMBER(3) NOT NULL, LASER_COLOR VARCHAR2(10) NOT NULL ) / ALTER TABLE LMF_LASER_COLORS_DEF ADD CONSTRAINT LMF_LASER_COLORS_DEF_PK PRIMARY KEY (LMF_COLOR_ID) / INSERT INTO LMF_LASER_COLORS_DEF VALUES (1, 'BLUE') / INSERT INTO LMF_LASER_COLORS_DEF VALUES (2, 'IRED') / /* LMF_RUN_IOV */ CREATE TABLE LMF_RUN_IOV ( LMF_IOV_ID NUMBER NOT NULL, TAG_ID NUMBER NOT NULL, RUN_IOV_ID NUMBER(10) NOT NULL, SUBRUN_NUM NUMBER NOT NULL, SEQUENCE_NUM NUMBER(4) NOT NULL, LMR NUMBER(3) NOT NULL, LASER_COLOR NUMBER(3) NOT NULL , LASER_TYPE NUMBER(4) NOT NULL, SUBRUN_START DATE NOT NULL, SUBRUN_END DATE NOT NULL, SUBRUN_TYPE VARCHAR2(20) NOT NULL, db_timestamp TIMESTAMP DEFAULT sys_extract_utc(SYSTIMESTAMP) NOT NULL ) / ALTER TABLE LMF_RUN_IOV ADD CONSTRAINT LMF_RUN_IOV_PK PRIMARY KEY (LMF_IOV_ID) / ALTER TABLE LMF_RUN_IOV ADD CONSTRAINT LMF_RUN_IOV_UK UNIQUE (RUN_IOV_ID,SUBRUN_NUM) / ALTER TABLE LMF_RUN_IOV ADD CONSTRAINT LMF_RUN_IOV_FK1 FOREIGN KEY (RUN_IOV_ID) REFERENCES RUN_IOV(IOV_ID) / ALTER TABLE LMF_RUN_IOV ADD CONSTRAINT LMF_RUN_IOV_FK2 FOREIGN KEY (TAG_ID) REFERENCES LMF_RUN_TAG(TAG_ID) / ALTER TABLE LMF_RUN_IOV ADD CONSTRAINT LMF_RUN_IOV_FK3 FOREIGN KEY (LASER_COLOR) REFERENCES LMF_LASER_COLORS_DEF(LMF_COLOR_ID) / CREATE TABLE RUN_LMF_SEQUENCE_DAT ( RUN_IOV_ID NUMBER(10) NOT NULL, SEQUENCE_NUM NUMBER(4) NOT NULL, USER_COMMENT VARCHAR2(4000) ) / ALTER TABLE RUN_LMF_SEQUENCE_DAT ADD CONSTRAINT RUN_LMF_SEQUENCE_DAT_PK PRIMARY KEY (RUN_IOV_ID, SEQUENCE_NUM) / ALTER TABLE RUN_LMF_SEQUENCE_DAT ADD CONSTRAINT RUN_LMF_SEQ_DAT_FK1 FOREIGN KEY (RUN_IOV_ID) REFERENCES RUN_IOV(IOV_ID) / /* LMF_RUN_IOV */ CREATE OR REPLACE VIEW LMF_SEQUENCE_DAT AS SELECT DISTINCT RUN_IOV_ID , SEQUENCE_NUM , MIN(SUBRUN_START) SEQ_START , MAX(SUBRUN_END) SEQ_END FROM LMF_RUN_IOV GROUP BY RUN_IOV_ID, SEQUENCE_NUM ; CREATE INDEX lmf_run_iov_startend_ix ON lmf_run_iov (subrun_start, subrun_end); CREATE INDEX lmf_run_iov_run_iov_id_ix ON lmf_run_iov (run_iov_id); /* LMF_LASER_CONFIG_DAT */ CREATE TABLE LMF_LASER_CONFIG_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, WAVELENGTH NUMBER, VFE_GAIN NUMBER, PN_GAIN NUMBER, LSR_POWER NUMBER, LSR_ATTENUATOR NUMBER, LSR_CURRENT NUMBER, LSR_DELAY_1 NUMBER, LSR_DELAY_2 NUMBER ) / ALTER TABLE LMF_LASER_CONFIG_DAT ADD CONSTRAINT LMF_LASER_CONFIG_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_CONFIG_DAT ADD CONSTRAINT LMF_LASER_CONFIG_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_RUN_DAT */ CREATE TABLE LMF_RUN_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, NEVENTS NUMBER, QUALITY_FLAG NUMBER ) / ALTER TABLE LMF_RUN_DAT ADD CONSTRAINT LMF_RUN_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_RUN_DAT ADD CONSTRAINT LMF_RUN_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_TEST_PULSE_CONFIG_DAT */ CREATE TABLE LMF_TEST_PULSE_CONFIG_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, VFE_GAIN NUMBER, DAC_MGPA NUMBER, PN_GAIN NUMBER, PN_VINJ NUMBER ) / ALTER TABLE LMF_TEST_PULSE_CONFIG_DAT ADD CONSTRAINT LMF_TEST_PULSE_CONFIG_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_TEST_PULSE_CONFIG_DAT ADD CONSTRAINT LMF_TEST_PULSE_CONFIG_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_LASER_BLUE_PULSE_DAT */ CREATE TABLE LMF_LASER_BLUE_PULSE_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FIT_METHOD NUMBER, MTQ_AMPL NUMBER, MTQ_TIME NUMBER, MTQ_RISE NUMBER, MTQ_FWHM NUMBER, MTQ_FW20 NUMBER, MTQ_FW80 NUMBER, MTQ_SLIDING NUMBER ) / ALTER TABLE LMF_LASER_BLUE_PULSE_DAT ADD CONSTRAINT LMF_LASER_BLUE_PULSE_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_BLUE_PULSE_DAT ADD CONSTRAINT LMF_LASER_BLUE_PULSE_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_LASER_BLUE_PRIM_DAT */ CREATE TABLE LMF_LASER_BLUE_PRIM_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG NUMBER, MEAN NUMBER, RMS NUMBER, PEAK NUMBER, APD_OVER_PNA_MEAN NUMBER, APD_OVER_PNA_RMS NUMBER, APD_OVER_PNA_PEAK NUMBER, APD_OVER_PNB_MEAN NUMBER, APD_OVER_PNB_RMS NUMBER, APD_OVER_PNB_PEAK NUMBER, APD_OVER_PN_MEAN NUMBER, APD_OVER_PN_RMS NUMBER, APD_OVER_PN_PEAK NUMBER, ALPHA NUMBER, BETA NUMBER, SHAPE_COR NUMBER ) / ALTER TABLE LMF_LASER_BLUE_PRIM_DAT ADD CONSTRAINT LMF_LASER_BLUE_PRIM_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_BLUE_PRIM_DAT ADD CONSTRAINT LMF_LASER_BLUE_PRIM_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_CALIB_PRIM_DAT */ CREATE TABLE LMF_CALIB_PRIM_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG NUMBER, MEAN NUMBER, RMS NUMBER, PEAK NUMBER ) / ALTER TABLE LMF_CALIB_PRIM_DAT ADD CONSTRAINT LMF_CALIB_PRIM_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_CALIB_PRIM_DAT ADD CONSTRAINT LMF_CALIB_PRIM_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_NLS_[LASR_COLOR]_DAT: will susbtitute LMF_CALIB_PRIM_DAT */ CREATE TABLE LMF_VERSIONS ( VERSION INTEGER NOT NULL, DESCRIPTION VARCHAR(200) ) / ALTER TABLE LMF_VERSIONS ADD CONSTRAINT LMF_VERSIONS_PK PRIMARY KEY (VERSION) / CREATE TABLE LMF_NLS_REF_BLUE_DAT ( NLS_REF_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, NORM NUMBER, LMF_IOV_ID NUMBER NOT NULL, IOV_START TIMESTAMP, IOV_END TIMESTAMP, VMIN INTEGER NOT NULL, VMAX INTEGER NOT NULL ) / ALTER TABLE LMF_NLS_REF_BLUE_DAT ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_PK PRIMARY KEY (NLS_REF_ID, LOGIC_ID) / ALTER TABLE LMF_NLS_REF_BLUE_DAT ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / ALTER TABLE LMF_NLS_REF_BLUE_DAT ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_VMIN_FK FOREIGN KEY (VMIN) REFERENCES LMF_VERSIONS(VERSION) / ALTER TABLE LMF_NLS_REF_BLUE_DAT ADD CONSTRAINT LMF_NLS_REF_BLUE_DAT_VMAX_FK FOREIGN KEY (VMAX) REFERENCES LMF_VERSIONS(VERSION) / CREATE TABLE LMF_NLS_BLUE_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG INTEGER, MEAN NUMBER, NLS_REF_ID NUMBER NOT NULL ) / ALTER TABLE LMF_NLS_BLUE_DAT ADD CONSTRAINT LMF_NLS_BLUE_DAT_PK PRIMARY KEY (LMF_IOV_ID, LOGIC_ID) / ALTER TABLE LMF_NLS_BLUE_DAT ADD CONSTRAINT LMF_NLS_BLUE_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / ALTER TABLE LMF_NLS_BLUE_DAT ADD CONSTRAINT LMF_NLS_BLUE_DAT_REF_FK FOREIGN KEY (NLS_REF_ID, LOGIC_ID) REFERENCES LMF_NLS_REF_BLUE_DAT(NLS_REF_ID, LOGIC_ID) / CREATE TABLE LMF_NLS_REF_IRED_DAT ( NLS_REF_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, NORM NUMBER, LMF_IOV_ID NUMBER NOT NULL, IOV_START TIMESTAMP, IOV_END TIMESTAMP, VMIN INTEGER NOT NULL, VMAX INTEGER NOT NULL ) / ALTER TABLE LMF_NLS_REF_IRED_DAT ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_PK PRIMARY KEY (NLS_REF_ID, LOGIC_ID) / ALTER TABLE LMF_NLS_REF_IRED_DAT ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / ALTER TABLE LMF_NLS_REF_IRED_DAT ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_VMIN_FK FOREIGN KEY (VMIN) REFERENCES LMF_VERSIONS(VERSION) / ALTER TABLE LMF_NLS_REF_IRED_DAT ADD CONSTRAINT LMF_NLS_REF_IRED_DAT_VMAX_FK FOREIGN KEY (VMAX) REFERENCES LMF_VERSIONS(VERSION) / CREATE TABLE LMF_NLS_IRED_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG INTEGER, MEAN NUMBER, NLS_REF_ID NUMBER NOT NULL ) / ALTER TABLE LMF_NLS_IRED_DAT ADD CONSTRAINT LMF_NLS_IRED_DAT_PK PRIMARY KEY (LMF_IOV_ID, LOGIC_ID) / ALTER TABLE LMF_NLS_IRED_DAT ADD CONSTRAINT LMF_NLS_IRED_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / ALTER TABLE LMF_NLS_IRED_DAT ADD CONSTRAINT LMF_NLS_IRED_DAT_REF_FK FOREIGN KEY (NLS_REF_ID, LOGIC_ID) REFERENCES LMF_NLS_REF_IRED_DAT(NLS_REF_ID, LOGIC_ID) / CREATE TABLE LMF_CORR_PARAM_DAT ( CORR_PARAM_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, LMF_IOV_ID NUMBER NOT NULL, P1 NUMBER, P2 NUMBER, P3 NUMBER, T1 NUMBER, T2 NUMBER, T3 NUMBER, P1_ERR NUMBER, P2_ERR NUMBER, P3_ERR NUMBER, IOV_START TIMESTAMP, IOV_END TIMESTAMP, FLAG INTEGER, VMIN INTEGER NOT NULL, VMAX INTEGER NOT NULL ) / ALTER TABLE LMF_CORR_PARAM_DAT ADD CONSTRAINT LMF_CORR_PARAM_DAT_PK PRIMARY KEY (CORR_PARAM_ID, LOGIC_ID) / ALTER TABLE LMF_CORR_PARAM_DAT ADD CONSTRAINT LMF_CORR_PARAM_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / ALTER TABLE LMF_CORR_PARAM_DAT ADD CONSTRAINT LMF_CORR_PARAM_DAT_VMIN_FK FOREIGN KEY (VMIN) REFERENCES LMF_VERSIONS(VERSION) / ALTER TABLE LMF_CORR_PARAM_DAT ADD CONSTRAINT LMF_CORR_PARAM_DAT_VMAX_FK FOREIGN KEY (VMAX) REFERENCES LMF_VERSIONS(VERSION) / /* RUN_LASERRUN_CONFIG_DAT */ CREATE TABLE RUN_LASERRUN_CONFIG_DAT ( IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, LASER_SEQUENCE_TYPE VARCHAR2(20), LASER_SEQUENCE_COND VARCHAR2(20) ) / ALTER TABLE RUN_LASERRUN_CONFIG_DAT ADD CONSTRAINT RUN_LASERRUN_CONFIG_DAT_PK UNIQUE (IOV_ID,LOGIC_ID) / ALTER TABLE RUN_LASERRUN_CONFIG_DAT ADD CONSTRAINT RUN_LASERRUN_CONFIG_DAT_FK FOREIGN KEY (IOV_ID) REFERENCES RUN_IOV(IOV_ID) / /* LMF_LASER_BLUE_PN_PRIM_DAT */ CREATE TABLE LMF_LASER_BLUE_PN_PRIM_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG NUMBER, MEAN NUMBER, RMS NUMBER, PEAK NUMBER, PNA_OVER_PNB_MEAN NUMBER, PNA_OVER_PNB_RMS NUMBER, PNA_OVER_PNB_PEAK NUMBER ) / ALTER TABLE LMF_LASER_BLUE_PN_PRIM_DAT ADD CONSTRAINT LMF_LASER_BLUE_PN_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_BLUE_PN_PRIM_DAT ADD CONSTRAINT LMF_LASER_BLUE_PN_PRIM_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* Infra red laser runs */ CREATE TABLE LMF_LASER_IRED_PN_PRIM_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG NUMBER, MEAN NUMBER, RMS NUMBER, PEAK NUMBER, PNA_OVER_PNB_MEAN NUMBER, PNA_OVER_PNB_RMS NUMBER, PNA_OVER_PNB_PEAK NUMBER ) / ALTER TABLE LMF_LASER_IRED_PN_PRIM_DAT ADD CONSTRAINT LMF_LASER_IRED_PN_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_IRED_PN_PRIM_DAT ADD CONSTRAINT LMF_LASER_IRED_PN_PRIM_DAT_FK FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_LASER_IRED_PULSE_DAT */ CREATE TABLE LMF_LASER_IRED_PULSE_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FIT_METHOD NUMBER, MTQ_AMPL NUMBER, MTQ_TIME NUMBER, MTQ_RISE NUMBER, MTQ_FWHM NUMBER, MTQ_FW20 NUMBER, MTQ_FW80 NUMBER, MTQ_SLIDING NUMBER ) / ALTER TABLE LMF_LASER_IRED_PULSE_DAT ADD CONSTRAINT LMF_LASER_IRED_PULSE_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_IRED_PULSE_DAT ADD CONSTRAINT LMF_LASER_IRED_PULSE_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / /* LMF_LASER_IRED_PRIM_DAT */ CREATE TABLE LMF_LASER_IRED_PRIM_DAT ( LMF_IOV_ID NUMBER NOT NULL, LOGIC_ID NUMBER NOT NULL, FLAG NUMBER, MEAN NUMBER, RMS NUMBER, PEAK NUMBER, APD_OVER_PNA_MEAN NUMBER, APD_OVER_PNA_RMS NUMBER, APD_OVER_PNA_PEAK NUMBER, APD_OVER_PNB_MEAN NUMBER, APD_OVER_PNB_RMS NUMBER, APD_OVER_PNB_PEAK NUMBER, APD_OVER_PN_MEAN NUMBER, APD_OVER_PN_RMS NUMBER, APD_OVER_PN_PEAK NUMBER, ALPHA NUMBER, BETA NUMBER, SHAPE_COR NUMBER ) / ALTER TABLE LMF_LASER_IRED_PRIM_DAT ADD CONSTRAINT LMF_LASER_IRED_PRIM_DAT_PK PRIMARY KEY (LMF_IOV_ID,LOGIC_ID) / ALTER TABLE LMF_LASER_IRED_PRIM_DAT ADD CONSTRAINT LMF_LASER_IRED_PRIM_DAT_FK1 FOREIGN KEY (LMF_IOV_ID) REFERENCES LMF_RUN_IOV(LMF_IOV_ID) / CREATE INDEX LMF_LASER_CONFIG_DAT_IX ON LMF_LASER_CONFIG_DAT(LMF_IOV_ID) / CREATE INDEX LMF_RUN_DAT_IX ON LMF_RUN_DAT(LMF_IOV_ID) / CREATE INDEX LMF_TEST_PULSE_CONFIG_DAT_IX ON LMF_TEST_PULSE_CONFIG_DAT(LMF_IOV_ID) / CREATE INDEX LMF_LASER_BLUE_PULSE_DAT_IX ON LMF_LASER_BLUE_PULSE_DAT(LMF_IOV_ID) / CREATE INDEX LMF_LASER_BLUE_PRIM_DAT_IX ON LMF_LASER_BLUE_PRIM_DAT(LMF_IOV_ID) / CREATE INDEX LMF_CALIB_PRIM_DAT_IX ON LMF_CALIB_PRIM_DAT(LMF_IOV_ID) / CREATE INDEX LMF_NLS_BLUE_DAT_IX ON LMF_NLS_BLUE_DAT(LMF_IOV_ID) / CREATE INDEX LMF_NLS_IRED_DAT_IX ON LMF_NLS_IRED_DAT(LMF_IOV_ID) / CREATE INDEX LMF_NLS_REF_BLUE_DAT_IX ON LMF_NLS_REF_BLUE_DAT(LMF_IOV_ID) / CREATE INDEX LMF_NLS_REF_IRED_DAT_IX ON LMF_NLS_REF_IRED_DAT(LMF_IOV_ID) / CREATE INDEX LMF_CORR_PARAM_DAT_IX ON LMF_CORR_PARAM_DAT(LMF_IOV_ID) / CREATE INDEX RUN_LASERRUN_CONFIG_DAT_IX ON RUN_LASERRUN_CONFIG_DAT(IOV_ID) / CREATE INDEX LMF_LASER_BLUE_PN_PRIM_DAT_IX ON LMF_LASER_BLUE_PN_PRIM_DAT(LMF_IOV_ID) / CREATE INDEX LMF_LASER_IRED_PN_PRIM_DAT_IX ON LMF_LASER_IRED_PN_PRIM_DAT(LMF_IOV_ID) / CREATE INDEX LMF_LASER_IRED_PULSE_DAT_IX ON LMF_LASER_IRED_PULSE_DAT(LMF_IOV_ID) / CREATE INDEX LMF_LASER_IRED_PRIM_DAT_IX ON LMF_LASER_IRED_PRIM_DAT(LMF_IOV_ID) /