Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Sql Server 2005 ͳ¼ÆÐÅÏ¢ÓÃ;

1, ʲôÊÇͳ¼ÆÐÅÏ¢ 
    ÒÔÏÂÊǹٷ½µÄ¶Ôͳ¼ÆÐÅÏ¢µÄÃèÊö£º
     °´ÕÕĬÈÏÉèÖã¬Èç¹û±íÖеÄijÁÐûÓÐË÷Òý£¬ÔòSQL Server»á×Ô¶¯Îª¸ÃÁд´½¨Í³¼Æ¡£È»ºó£¬²éѯÓÅ»¯Æ÷ÆÀ¹À¸ÃÁÐÖÐÊý¾Ý·Ö²¼·¶Î§µÄͳ¼ÆÐÅÏ¢£¬ÒÔÑ¡ÔñÒ»¸ö¸üΪÓÐЧµÄ²éѯ´¦Àí·½°¸¡£·Ö±æ×Ô¶¯´´½¨µÄͳ¼ÆºÜ¼òµ¥£¬ÔÚSQL Server 7.0ºÍSQL Server 2000ÖУ¬×Ô¶¯´´½¨µÄͳ¼ÆµÄǰ׺Ϊ_WA_Sys¡£
 
  ¸öÈ˸ÐÏ룺  
    ÒÔǰ¶Ô_WA_Sys¿ªÍ·µÄͳ¼ÆÐÅÏ¢Ò»Ö±²»ÖªµÀÓÐʲôÓã¬ÔÚѧϰÁËoracleʱµÄCBOºÍÈý¸öËã·¨£¨Ç¶Ì×Ñ­»·£¬ºÏ²¢Á¬½ÓºÍhashÁ¬½Ó£©²Å·¢ÏÖÕâ¸ö_WA_Sys¿ªÍ·µÄͳ¼ÆÐÅÏ¢ºÍË÷ÒýµÄͳ¼ÆÐÅÏ¢¶ÔÎÒÃÇÓû§Ã»Ó㬶ÔÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£
   2, ͳ¼ÆÐÅÏ¢ÄÚÈÝ£º
dbcc show_statistics('[[zping.com]]]',idx_operator)
   ÔËÐÐÉÏÃæÃüÁîÒԺ󣬳öÀ´ÏÂÁÐÐÅÏ¢£º    
Name         Updated                        Rows Rows      Sampled    Steps     Density           Average key length    String Index
idx_operator 07 24 2008  8:15PM   721370          721370     200      0.002035875  63.99907               YES
 ÕâÀïµÄÐÅϢ˵Ã÷£º
     name:ͳ¼ÆÐÅÏ¢µÄÃû³Æ¡£ Updated :ÉÏÒ»´Î¸üÐÂͳ¼ÆÐÅÏ¢µÄÈÕÆÚºÍʱ¼ä   
     Rows :±íÖеÄÐÐÊý¡£ Rows Sampled :ͳ¼ÆÐÅÏ¢µÄ³éÑùÐÐÊý¡£
     Steps:·Ö·¢²½ÖèÊý(ÔÚsql server×î¶à200²½£©  Average key length :ËùÓÐË÷ÒýÁÐµÄÆ½¾ù³¤¶È
   ÕâЩÐÅÏ¢ÊǶÔͳ¼ÆÐÅÏ¢Ò»¸ö»ã×Ü
   »¹ÓÐÏÂÁÐÐÅÏ¢£º   
All density     Average Le


Ïà¹ØÎĵµ£º

£¨×ª£©ÀûÓà Sql Öв鿴±í½á¹¹ÐÅÏ¢

ת×Ô£ºhttp://hi.baidu.com/cszoo/blog/item/2439a5f517c19c2dbc31093c.html
 
£¨1£©
SELECT
±íÃû=case when a.colorder=1 then d.name else '' end,
±í˵Ã÷=case when a.colorder=1 then isnull(f.value,'') else '' end,
×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
±êʶ=case when COLUMNPROPERTY( a.id,a.name,' ......

DB2 SQLÐÔÄÜÓÅ»¯Ïà¹ØµÄ10´óÒªËØ

ÏÂÃæÌá³öÁË10ÌõºÍDB2 SQLÐÔÄÜÏà¹ØµÄ10ÌõÒòËØ£º
1¡¢ÌṩÊʵ±µÄͳ¼ÆÐÅÏ¢
¶ÔDB2ÓÅ»¯¹ÜÀíÆ÷£¨otimizer£©¶øÑÔ£¬ÈçºÎ¸ü¼ÓÓÐЧµÄÖ´ÐÐSQLÓï¾äÊÇÓÉ´æÔÚÓÚDB2 catalogÖеÄͳ¼ÆÐÅÏ¢¾ö¶¨µÄ£¬ÓÅ»¯Æ÷ÀûÓÃÕâЩÐÅÏ¢¾ö¶¨×îÓÅ»¯µÄ·¾¶¡£
Òò´Ë£¬ÎªÁ˱£³ÖϵͳÄܹ»×ö³ö×î¼ÑÑ¡Ôñ£¬ÐèÒª¾­³£µÄÔËÐÐRunstatsÃüÁÀ´±£³Öϵͳͳ¼ÆÐÅÏ¢µÄ¼°Ê±ÓÐЧ¡£Ô ......

¸ßЧSQL²éѯ֮Ë÷Òý£¨V£©

ÏÈÕ¾ÔÚÓ¦ÓóÌÐòµÄ½Ç¶È˵˵ËüÃǵIJ»Í¬¡£
1¡¢ Ö±½ÓÆ´ SQL
¾ÍÏñ´ó¼ÒÁ˽âµÄÄÇÑù£¬Ö±½ÓÆ´ SQL ´øÀ´ÁË SQL ×¢Èë¹¥»÷£¬´øÀ´ÁËÆ´Ê±Ð©ÐíµÄÐÔÄÜËðʧ£¬µ«ÊÇÆ´²»ÓÃÌí¼Ó SqlParameter £¬»áÉÙдºÜ¶à´úÂë——ºÜ¶àÈËϲ»¶Ö±½ÓÆ´£¬Ò²Ðí¾ÍÒòΪÕâµã¡£ÕâÖÖ×ö·¨»á°ÑÄãÆ´ºÃµÄ SQL Ô­ÑùÖ±½Ó·¢Ë͵½ DB ·þÎñÆ÷È¥Ö´ÐС££¨×¢ÒâÀàËÆ &rdquo ......

SQL²é±íÃû¡¢×Ö¶ÎÃû¡¢±í˵Ã÷¡¢×Ö¶Î˵Ã÷

SQL ²é¿´ËùÓбíÃû£º
select name from sysobjects where type='U'
²éѯ±íµÄËùÓÐ×Ö¶ÎÃû£º
Select name from syscolumns Where ID=OBJECT_ID('±íÃû')
select * from information_schema.tables
select * from information_schema.views
select * from information_schema.columns
ACCESS
²é¿´ËùÓбíÃû£º
se ......

C#ÏîÄ¿´ò°ü£¬²¢×Ô¶¯°²×°SQLÊý¾Ý¿â

Ó¦Ò»Î»ÍøÓѵÄÐèÇ󣬲¢ÐÞÕýÁËMVPÀîºé¸ù".NETƽ̨ÏÂWEBÓ¦ÓóÌÐòµÄ²¿Êð(°²×°Êý¾Ý¿âºÍ×Ô¶¯ÅäÖÃ)"ÖеÄosqlÓ÷¨´íÎó£¬ÒѲâÊÔͨ¹ý¡£
Ò»).´´½¨²¿ÊðÏîÄ¿
1. ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£
2. ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ