안녕하세요.

현재 MSSQL2000에서 MSSQL2005로 마이그레이션을 했습니다.

컬럼속성, 인덱스등 모두같은데요..

 SELECT SIDO, GUGUN, ZIPCODE
    , ADDRESS
    , DBO.TEXT_SPLIT(ZIPCODE, '-', 1) ZIPCODE1
    , DBO.TEXT_SPLIT(ZIPCODE, '-', 2) ZIPCODE2
FROM DBO.TS_ZIPCODE_TB (NOLOCK)
WHERE SIDO = '서울'
 AND GUGUN = '강남구'

MSSQL 2000에서 IDX_TS_ZIPCODE_TB_02 -(SIDO,GUGUN 으로 결합인덱스) : Index Seek 이리타구요..

MSSQL 2005에서 IDX_TS_ZIPCODE_TB_02 -(SIDO,GUGUN 으로 결합인덱스) : Clustered Index Scan 이리탑니다..

그래서 강제로 WITH (INDEX (IDX_TS_ZIPCODE_TB_02)) 인덱스를 타게하면 실행계획에 Index Seek 나옵니다..

왜그런건가요??

답변좀 부탁드립니다..

*통계정보

 실행계획

31,1,SELECT SIDO, GUGUN, ZIPCODE
    , ADDRESS
    , DBO.TEXT_SPLIT(ZIPCODE, '-', 1) ZIPCODE1
    , DBO.TEXT_SPLIT(ZIPCODE, '-', 2) ZIPCODE2
FROM DBO.TS_ZIPCODE_TB
WHERE SIDO = '서울'
 AND GUGUN = '강남구',1,1,0,NULL,NULL,NULL,NULL,24.05578,NULL,NULL,NULL,0.06190631,NULL,NULL,SELECT,0,NULL
31,1,  |--Compute Scalar(DEFINE:([Expr1004]=[TOWNSTORY].[dbo].[TEXT_SPLIT]([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE],'-',(1)), [Expr1005]=[TOWNSTORY].[dbo].[TEXT_SPLIT]([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE],'-',(2)))),1,2,1,Compute Scalar,Compute Scalar,DEFINE:([Expr1004]=[TOWNSTORY].[dbo].[TEXT_SPLIT]([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE],'-',(1)), [Expr1005]=[TOWNSTORY].[dbo].[TEXT_SPLIT]([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE],'-',(2))),[Expr1004]=[TOWNSTORY].[dbo].[TEXT_SPLIT]([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE],'-',(1)), [Expr1005]=[TOWNSTORY].[dbo].[TEXT_SPLIT]([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE],'-',(2)),24.05578,0,2.405578E-06,133,0.06190631,[TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[SIDO], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[GUGUN], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ADDRESS], [Expr1004], [Expr1005],NULL,PLAN_ROW,0,1
31,1,       |--Clustered Index Scan(OBJECT:([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[IDX_TS_ZIPCODE_TB_01]), WHERE:([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[SIDO]='서울' AND [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[GUGUN]='강남구')),1,3,2,Clustered Index Scan,Clustered Index Scan,OBJECT:([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[IDX_TS_ZIPCODE_TB_01]), WHERE:([TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[SIDO]='서울' AND [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[GUGUN]='강남구'),[TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[SIDO], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[GUGUN], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ADDRESS],24.05578,0.04979167,0.0067988,109,0.05659047,[TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ZIPCODE], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[SIDO], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[GUGUN], [TOWNSTORY].[dbo].[TS_ZIPCODE_TB].[ADDRESS],NULL,PLAN_ROW,0,1