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)
µ±±ØÐë¶ÔÁÙʱ±íÏÔʽµØ´´½¨Ë÷Òýʱ£¬»ò¶à¸ö´æ´¢¹ý³Ì»òº¯Êý±ØÐëʹÓñíֵʱ£¬ÁÙʱ±íºÜÓÐÓá£Ê¹ÓôóÈÝÁ¿ÈÕ־ģʽ¿ÉÒÔÌá¸ßÁÙʱ±í´óÁ¿²åÈëÊý¾ÝµÄЧÂÊ¡£
Ïà¹ØÎĵµ£º
DELETE from SCOTT.EMP;
DROP from SCOTT.EMP;
TRUNCATE from EMP;
Ïàͬµã
truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã:
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigge ......
Ò»).´´½¨²¿ÊðÏîÄ¿
1. ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£
2. ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñ ......
ÐÔÄÜ¼à¿ØÖ®¼à¿Ø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 Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
1. CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼±í´ïʽÀ´ÅжÏÊý¾ ......
SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
ʹÓÓ*&rdquo ......