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

sql server2005²éѯÓÅ»¯½¨Òé


²éѯÓÅ»¯µÄÄ¿µÄÊÇÌá¸ßÊý¾Ý¼ìË÷ËÙ¶È£¬Ìá¸ßÊý¾Ý¼ìË÷Òâζ׿õÉÙ´ÅÅÌ
IO
¶ÁÈ¡»òÕßÂß¼­ÄÚ´æ¶ÁÈ¡´ÎÊý£¬ÕâÐèÒª´ÓÁ½¸ö·½ÃæÈëÊÖ£ºÊý¾ÝÒª¾¡¿ÉÄܵĻº´æµ½ÄÚ´æ¡¢¾¡¿ÉÄܵÄʹÓÃË÷Òý¡£ÄÚ´æµÄÎÊÌâ¿ÉÒԲμû
 
:
http://msdn.microsoft.com/zh-cn/library/ms188284.aspx
£¬±¾ÎÄÖ÷ÒªÊÇÌåÏÖÈçºÎʹÓÃË÷ÒýÀ´Ìá¸ßËÙ¶È¡£¾ßÌå·½·¨£º
1)    
Ñø³ÉÁ¼ºÃµÄ±à³Ìϰ¹ß£¬±ÈÈçSARG
ÓÅ»¯£¨Õâ¸öºÃÏñÀ´×ÔÓÚsybase
£©
2)    
ʹÓòéѯ¼Æ»®£¬¿´Ä³Ò»¸ö²éѯÊÇ·ñÊÇʹÓÃÁËË÷Òý£¬ÊÇ·ñÊÇʹÓÃÁËÁÙʱ±í£¬¾¡Á¿Ê¹ÓÃË÷Òý£¬±ÜÃâÁÙʱ±í
3)    
ʹÓòéѯÓÅ»¯¹ËÎÊ£¬Ëü¿ÉÒÔ°ïÖúÄãÅжϲéѯÊÇ·ñÓÅ»¯£¬²¢ÌáʾÄ㽨Á¢Ë÷Òý
4)    
ʹÓÃSET STATISTICS IO
ÃüÁ²é¿´´ÅÅ̶ÁÈ¡´ÎÊý£¬¾¡Á¿ÎïÀí´ÅÅ̺ÍÂß¼­¶ÁÈ¡´ÎÊýÉÙ
5)    
½¨Á¢Ö÷¼ü£¬Ö÷¼üÊǾ۴ØË÷Òý£¬Êý¾ÝÐлùÓÚ¾Û¼¯Ë÷Òý¼ü°´Ë³Ðò´æ´¢
6)    
ʹÓÃ×éºÏË÷Òý£¬±ÜÃâOR
²Ù×÷·ûʹÓÃÁÙʱ±í£¬select * from table where a=1 or b=2,
¿ÉÒÔ¿¼ÂÇ´´½¨a
and b
µÄ×éºÏË÷Òý
7)    
´óÊý¾ÝÁ¿±íʹÓÃÒÑ·ÖÇø±í£¬¾ßÌå²Î¼û£º
http://msdn.microsoft.com/zh-cn/library/ms345146
£¨
SQL.90
£©
.aspx
8)    
ʹÓô洢¹ý³Ì´úÌæ¸´ÔÓsql
Óï¾ä
9)    
´æ´¢¹ý³ÌÖÐʹÓñí±äÁ¿¶ø²»Ê¹ÓÃÁÙʱ±í£¬Í¨³££¬±í±äÁ¿¿ÉÌṩ¸üÓÐЧµÄ²éѯ ´¦Àí£º
table

±äÁ¿µÄÐÐΪÀàËÆÓÚ¾Ö²¿±äÁ¿£¬ÓÐÃ÷È·¶¨ÒåµÄ×÷ÓÃÓò£»ÔÚ´æ´¢¹ý³ÌÖÐʹÓÃ
table

±äÁ¿ÓëʹÓÃÁÙʱ±íÏà±È£¬¼õÉÙÁË´æ´¢¹ý³ÌµÄÖØÐ±àÒëÁ¿£»Éæ¼°
table

±äÁ¿µÄÊÂÎñÖ»ÔÚ
table

±äÁ¿¸üÐÂÆÚ¼ä´æÔÚ¡£Òò´Ë¼õÉÙÁË
table

±äÁ¿¶ÔËø¶¨ºÍ¼Ç¼×ÊÔ´µÄÐèÇó¡£µ«²»ÄÜÏÔʽ´´½¨
table

±äÁ¿µÄË÷Òý£¬Ò²²»±£Áô
table

±äÁ¿µÄÈκÎͳ¼ÆÐÅÏ¢¡£ÔÚijЩÇé¿öÏ£¬¿ÉÒÔͨ¹ý¸ÄÓÃÖ§³ÖË÷ÒýºÍͳ¼ÆÐÅÏ¢µÄÁÙʱ±íÀ´¸ÄÉÆÐÔÄÜ¡£¾ßÌå²Î¼û£º
http://msdn.microsoft.com/zh-cn/library/ms175010.aspx
10)
µ±±ØÐë¶ÔÁÙʱ±íÏÔʽµØ´´½¨Ë÷Òýʱ£¬»ò¶à¸ö´æ´¢¹ý³Ì»òº¯Êý±ØÐëʹÓñíֵʱ£¬ÁÙʱ±íºÜÓÐÓá£Ê¹ÓôóÈÝÁ¿ÈÕ־ģʽ¿ÉÒÔÌá¸ßÁÙʱ±í´óÁ¿²åÈëÊý¾ÝµÄЧÂÊ¡£


Ïà¹ØÎĵµ£º

[SQLɾ³ý] SQLÓï¾äÖÐdelete, drop, truncate±È½Ï


DELETE from SCOTT.EMP;
DROP from SCOTT.EMP;
TRUNCATE from EMP;
Ïàͬµã 
truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý 
²»Í¬µã: 
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå) 
    dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigge ......

asp.net ÖÆ×÷°²×°°ü²¢×Ô¶¯°²×°SQLÊý¾Ý¿â

Ò»).´´½¨²¿ÊðÏîÄ¿    
  1.   ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£    
  2.   ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñ ......

ÐÔÄÜ¼à¿ØÖ®¼à¿ØSQLÓï¾ä

ÐÔÄÜ¼à¿ØÖ®¼à¿ØSQLÓï¾ä 
·ÖÎö±í 
analyze table tablename compute statistics for all indexes; 
analyze table tablename compute statistics for all indexed columns; 
analyze table tablename compute statistics for table; 
¼à¿ØÊÂÀýµÄµÈ´ý 
select event,sum(decode(wait_Tim ......

SQL 2005 ´´½¨Ô¼Êø

²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
 
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
 
1.       CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼­±í´ïʽÀ´ÅжÏÊý¾ ......

SQLÓï¾äÓÅ»¯

SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
 
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
       ʹÓÓ*&rdquo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ