informix tuning study 03.08.22

케이원 : 수강신청관련 테이블에 대량의 데이타 로딩 후
update statistics를 수행전과 수행후의 responding time을 체크해 본다.

. 대량의 데이타가 로드된 테이블
        - eboard, cmember, member,

UPDATE STATISTICS
        [
                {
                HIGH [FOR TABLE [{table-name|synonym-name} [(column-list)]]]
                        [RESOLUTION percentage]
                |
                MEDIUM [FOR TABLE [{table-name|synonym-name} [(column-list)]]]
                  [RESOLUTION percentage [confidence-percentage]]
                |
                [LOW] [FOR TABLE [{table-name|synonym-name} [(column-list)]]]
                        [DROP DISTRIBUTIONS]
                }
        |
        FOR PROCEDURE [procedure-name]
        ]


set explain on;
select org_sect, year,term, lec_cd, lec_note_form ,title
   from eboard
        where year='2003' and lec_cd='1036422000621';

update statistics high for table eboard;


set explain on;
select user_id, org_sect,year from cmember
   where user_id='20317038';

update statistics high for table cmember;

set explain on;
select --+ ordered index (cmember , xpkcmember) c.user_id, c.org_sect,c.year
   from cmember c , eboard d
   where user_id='20317038' and c.org_sect=d.org_sect;
* itislord님에 의해서 게시물 복사되었습니다 (2005-04-24 14:11)