RC-LS, CheckEye DX

<p>650건짜리 DPC(191)</p>

<p> </p>

<p>1. CD에서 와력변경<br />
(전) 09:36:00 - 09:41:31 = 5분31초<br />
(후) 09:46:45 - 09:52:10 = 5분25초</p>

<p>2. 마스타INDEX생성</p>

<p>(전) 마스타INDEX생성&lt;br /&gt;
(전) 09:58:14 - 10:03:39 = 5분25초<br />
(후) 14:35:58 - 14:41:32 = 5분34초<br />
(후) 14:59:44 - 15:05:17 = 5분33초</p> 5분25초&lt;/p&gt;

<p>3. CD레코드 스킵<br />
13:08:07 - 13:13:23 = 5분16초</p>

<p>4. CO레코드 스킵<br />
13:15:53 - 13:21:14 = 5분21초</p>

<p>5. IY레코드 스킵<br />
13:23:40 - 13:29:02 = 5분22초</p>

<p>6. SI레코드 스킵<br />
13:30:56 - 13:36:17 = 5분21초</p>

<p>6. SB레코드 스킵<br />
13:38:31 - 13:43:54 = 5분23초</p>

<p>7. view테이블생성<br />
13:54:23 - 13:59:58 = 5분35초</p>

<p><br />
수정전<br />
13:59:19 - 13:59:44 = 25초</p>

<p>15:16:25 - 15:16:45 = 20초</p>

<p>15:23:31 - 15:23:50 = 19초</p>

<p>15:25:13 - 15:25:32 = 19초</p>

<p>15:41:09 - 15:41:25 = 16초</p>

<p>15:42:28 - 15:42:36 = 8초</p>

<p>15:47:11 - 15:47:17  = 6초</p>

<p><br />
650건짜리 DPC(rc1)<br />
16:17:20 - 16:26:55 = 9분35초<br />
16:38:10 - 16:47:32 = 9분22초</p>

<p>650건짜리 DPC(rc2)<br />
16:00:46 - 16:06:30 = 5분44초<br />
16:08:56 - 16:14:17 = 5분21초</p>

<p>1772건짜리 MED(rc1)<br />
16:59:19 - 17:09:28 = 10분09초</p>

<p>1772건짜리 MED(rc2)<br />
17:11:44 - 17:20:06 = 9분20초</p>

<p>371건짜리 MED(rc1)<br />
17:32:42 - 17:33:19 = 35초</p>

<p>371건짜리 MED(rc2)<br />
17:30:20 - 17:30:43 = 23초</p>

<p> </p>

<p> </p>

<p>CREATE INDEX ix_mtb0100m_pk1 ON us_mt.mtb0100m (scd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0200m_pk1 ON us_mt.mtb0200m (ycd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0300m_pk1 ON us_mt.mtb0300m (tcd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0400m_pk1 ON us_mt.mtb0400m (bcd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0500m_pk1 ON us_mt.mtb0500m (zcd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0600m_pk1 ON us_mt.mtb0600m (ccd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0700m_pk1 ON us_mt.mtb0700m (mcd,adpt_frdt,adpt_todt);<br />
CREATE INDEX ix_mtb0800m_pk1 ON us_mt.mtb0800m (hcd,adpt_frdt,adpt_todt);<br />
COMMIT;</p>