FIX: ¸í½ÃÀû UPDATE STATISTICS ¸í·É ½ÇÇà °æ¿ì A ±³Âø »óÅ°¡ ¹ß»ýÇÑ´Ù

±â¼ú ÀÚ·á: 826754 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
±â°è ¹ø¿ªµÈ ¹®¼­±â°è ¹ø¿ª °íÁö »çÇ× º¸±â
# ¹ö±×: 470125 (SHILOH_BUGS)
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

Çö»ó

µ¿ÀÏÇÑ Å×ÀÌºí¿¡ ´ëÇØ ¸í½ÃÀû UPDATE STATISTICS ¸í·ÉÀ» µ¿½Ã¿¡ µÎ °³ÀÇ ¼­·Î ´Ù¸¥ ¿¬°áÀ» ½ÇÇàÇÏ¸é µÎ °³ÀÇ ¿¬°áÀ» ±³Âø »óÅ°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¬°á Áß Çϳª¸¦ ´ÙÀ½°ú °°Àº ¿À·ù ¸Þ½ÃÁö°¡ ¹Þ°í UPDATE STATISTICS ¸í·ÉÀ» Ãë¼ÒÇß½À´Ï´Ù.
¼­¹ö: ¿À·ù ¸Þ½ÃÁö 1205 ¼öÁØ 3 13, 50, »óÅ ÁÙ
Æ®·£Àè¼Ç (ÇÁ·Î¼¼½º ID 52) Àá±Ý ¸®¼Ò½º¸¦ ´Ù¸¥ ÇÁ·Î¼¼½º¿¡ ±³Âø ¹× ±³Âø »óÅ·Π¼±ÅõǾú½À´Ï´Ù. Æ®·£Àè¼ÇÀ» ´Ù½Ã ½ÇÇàÇϽʽÿÀ.
±³Âø »óÅ ¹× ÇØ´ç ÇÔ²² Á¦°øµÇ´Â 1205 ¿À·ù¸¦ ÀÌ »óȲÀ» °íÀ¯ÇÏÁö ¾Ê½À´Ï´Ù. ´Ù¸¥, °ü·ÃµÇÁö ¾ÊÀº ¿©·¯ ½Ã³ª¸®¿À¿¡¼­ ±³Âø »óÅ°¡ ¹ß»ýÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÃßÀû Ç÷¡±× 1204ÀÌ Æ¯Á¤ ±³Âø »óÅ¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸¸¦ ĸóÇÏ·Á¸é °æ¿ì µÎ ¿¬°á (°³Ã¼ ID 2) sysindexes Å×ÀÌºí¿¡¼­ Ŭ·¯½ºÅÍµÈ À妽º KEY ¸®¼Ò½º ±³Âø »óÅ°¡ ÂüÁ¶ÇϽʽÿÀ. µÎ ¿¬°á Áß Çϳª¸¦ ¾÷µ¥ÀÌÆ® Àá±ÝÀº °øÀ¯ Àá±ÝÀ» º¯È¯ÇÒ ½ÃµµÇÏ°í ¹® À¯Çü¿¡ ´ëÇØ UPDATE STATISTICS µÎ ¿¬°á·Î ÃßÀû Ç÷¡±× 1204 °á°ú¸¦ º¸°íÇÕ´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

¼­ºñ½º ÆÑ Á¤º¸

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
290211
(http://support.microsoft.com/kb/290211/ )
ÃֽŠSQL Server 2000 ¼­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý

ÇÖÇȽº Á¤º¸

ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ÆÄÀÏ Æ¯¼ºÀ» °¡Áý´Ï´Ù (¶Ç´Â ÀÌ»ó) ´ÙÀ½ Ç¥¿¡. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿­µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼­´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼­ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ. 
   Date         Time   Version            Size    File name
   -------------------------------------------------------------------
   31-May-2003  18:45  2000.80.818.0      78,400  Console.exe      
   25-Jun-2003  01:01  2000.80.818.0      33,340  Dbmslpcn.dll     
   25-Apr-2003  02:12                    786,432  Distmdl.ldf
   25-Apr-2003  02:12                  2,359,296  Distmdl.mdf
   30-Jan-2003  01:55                        180  Drop_repl_hotfix.sql
   23-Jun-2003  22:40  2000.80.837.0   1,557,052  Dtsui.dll        
   23-Jun-2003  22:40  2000.80.837.0     639,552  Dtswiz.dll       
   24-Apr-2003  02:51                    747,927  Instdist.sql
   03-May-2003  01:56                      1,581  Inst_repl_hotfix.sql
   08-Feb-2003  06:40  2000.80.765.0      90,692  Msgprox.dll      
   01-Apr-2003  02:07                      1,873  Odsole.sql
   05-Apr-2003  01:46  2000.80.800.0      62,024  Odsole70.dll     
   07-May-2003  20:41  2000.80.819.0      25,144  Opends60.dll     
   02-Apr-2003  21:48  2000.80.796.0      57,904  Osql.exe         
   02-Apr-2003  23:15  2000.80.797.0     279,104  Pfutil80.dll     
   04-Aug-2003  18:17                    550,780  Procsyst.sql
   22-May-2003  22:57                     19,195  Qfe469571.sql
   11-Jul-2003  17:04                  1,084,147  Replmerg.sql
   04-Apr-2003  21:53  2000.80.798.0     221,768  Replprov.dll     
   08-Feb-2003  06:40  2000.80.765.0     307,784  Replrec.dll      
   13-Aug-2003  16:28                  1,086,797  Replsys.sql
   13-Aug-2003  16:28                    986,603  Repltran.sql
   29-Jul-2003  20:13  2000.80.819.0     492,096  Semobj.dll       
   31-May-2003  18:27  2000.80.818.0     172,032  Semobj.rll
   05-Aug-2003  21:06                    127,884  Sp3_serv_uni.sql
   01-Jun-2003  01:01  2000.80.818.0   4,215,360  Sqldmo.dll       
   07-Apr-2003  17:44                     25,172  Sqldumper.exe    
   19-Mar-2003  18:20  2000.80.789.0      28,672  Sqlevn70.rll
   02-Jul-2003  00:18  2000.80.834.0     180,736  Sqlmap70.dll     
   08-Feb-2003  06:40  2000.80.765.0      57,920  Sqlrepss.dll     
   13-Aug-2003  20:04  2000.80.851.0   7,598,161  Sqlservr.exe     
   25-Jul-2003  21:44  2000.80.845.0     590,396  Sqlsort.dll      
   08-Feb-2003  06:40  2000.80.765.0      45,644  Sqlvdi.dll       
   25-Jun-2003  01:01  2000.80.818.0      33,340  Ssmslpcn.dll     
   01-Jun-2003  01:01  2000.80.818.0      82,492  Ssnetlib.dll     
   01-Jun-2003  01:01  2000.80.818.0      25,148  Ssnmpn70.dll     
   01-Jun-2003  01:01  2000.80.818.0     158,240  Svrnetcn.dll     
   31-May-2003  18:59  2000.80.818.0      76,416  Svrnetcn.exe     
   30-Apr-2003  23:52  2000.80.816.0      45,132  Ums.dll          
   02-Jul-2003  00:19  2000.80.834.0      98,816  Xpweb70.dll
Âü°í ÆÄÀÏ Á¾¼Ó °ü°è·Î ÀÎÇØ °¡Àå ÃÖ±ÙÀÇ ÇÖÇȽº³ª ÀÌ·¯ÇÑ ÆÄÀÏÀÌ Æ÷ÇÔµÈ ±â´ÉÀ» Ãß°¡ ÆÄÀÏÀÌ µé¾î ÀÖ½À´Ï´Ù.

ÀÌ ¼öÁ¤ ÇÁ·Î±×·¥Àº SQL Server ºôµå ¹øÈ£¸¦ 851, ÀÖÀ¸¸ç À̸¦ SQL Server 2000 ¼­ºñ½º ÆÑ 3 (SP3) ½ÇÇà ÁßÀÎ ÄÄÇ»ÅÍ ¶Ç´Â SQL Server SP3 ±â¹Ý ÇÖÇȽº ºôµå Àû¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

Microsoft ¹®Á¦´Â ÀÌ ¹®¼­ÀÇ ½ÃÀÛ ºÎºÐ¿¡ ³ª¿­ÇÑ Á¦Ç°¿¡¼­ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù. ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼­ºñ½º ÆÑ 4¿¡¼­ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á °úÁ¤

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é UPDATE STATISTICS¿¡¼­ µÎ °³ÀÇ ¿¬°áÀÌ °°Àº Å×ÀÌºí¿¡ ´ëÇØ µ¿½Ã¿¡ ½ÇÇàÇÏÁö ¸¶½Ê½Ã¿À.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Ãß°¡ Á¤º¸

ÀÌ ¹®Á¦´Â °æ¿ì¿¡¸¸ ¸í½ÃÀû UPDATE STATISTICS ¸í·ÉÀ» ¹ß»ýÇϰųª ÀúÀå ÇÁ·Î½ÃÀú¿¡ ´ëÇÑ sp_updatestats. sp_updatestats ÇÁ·Î½ÃÀú°¡ ½ÇÇàµÉ UPDATE STATISTICS ÀúÀåµË´Ï´Ù. ÀÌ ¹®Á¦´Â ÀÚµ¿ ¾÷µ¥ÀÌÆ® Åë°è ¶Ç´Â µ¥ÀÌÅͺ£À̽º Åë°è ÀÚµ¿ ÀÛ¼º ¿É¼ÇÀ¸·Î ÀÎÇØ ¶Ç´Â ¸í½ÃÀû CREATE STATISTICS ÀÎÇØ ¸í·É ¹ß»ýÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ ÇÖÇȽº¸¦ °°Àº Å×ÀÌºí¿¡ Åë°è¸¦ ÀÛ¼º ¹× ÀÚµ¿ ¾÷µ¥ÀÌÆ® Åë°è À̺¥Æ®°¡ ÀÌ¹Ì serializeµÇÁö µ¿ÀÏÇÑ ¹æ½ÄÀ¸·Î µ¿ÀÛÇÏ´Â UPDATE STATISTICS ¸í·ÉÀÇ serializeÇÕ´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ó¼º

±â¼ú ÀÚ·á: 826754 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 7.3
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
Å°¿öµå:?
kbmt kbhotfixserver kbqfe kbqfe kbsqlserv2000presp4fix kbfix kbbug KB826754 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

 
À§·Î °¡±âÀ§·Î °¡±â