ÉϺ£´óѧÊý¾Ý¿â1

Êý¾Ý¿âʵÑ鱨¸æ£¨Ò»£©

µÚ3ÖÜ£¨µÚËÄÕ£º³ý·¨¡¢¾ÛºÏº¯Êý¡¢·Ö×é¡¢¼¯ºÏ²Ù×÷£¬ÍâÁ¬½Ó×Ôѧ£©

Ò»¡¢ÊµÑé¿Î£º

1. ÑéÖ¤ÔÚ1000Íò¸öÒÔÉϼǼʱÔÚË÷ÒýºÍ²»Ë÷ÒýʱµÄ²éѯʱ¼äÇø±ð¡£ 1£© ½¨Á¢30WÌõ¼Ç¼ declare @i int set @i=1 while @i<300000 begin

insert into Table_1 values(@i) set @i=@i+1 end

2£© 佨Á¢Ë÷Òýǰ²éѯ set statistics time on select id from Table_1 where id=200000

set statistics time off

µÚ 9 Ò³ ¹² 9 Ò³

Êý¾Ý¿âʵÑ鱨¸æ£¨Ò»£©

3£© ÒÔ½µÐò½¨Á¢idË÷Òýºó²éѯ set statistics time on select id from Table_1 where id=200000

set statistics time off

2. ²éѯÿ¸öѧÉúÑ¡¿ÎÇé¿ö£¨°üÀ¨Ã»ÓÐÑ¡Ð޿γ̵ÄѧÉú£©¡£

µÚ 10 Ò³ ¹² 10 Ò³

Êý¾Ý¿âʵÑ鱨¸æ£¨Ò»£©

3. ¼ìË÷ËùÓпγ̶¼Ñ¡Ð޵ĵÄѧÉúµÄѧºÅÓëÐÕÃû¡£ ×¢£º£¨Îª¼ì²é³ö½á¹û£¬ÓÐÐ޸ıíÖÐÊý¾Ý£©

µÚ 11 Ò³ ¹² 11 Ò³

Êý¾Ý¿âʵÑ鱨¸æ£¨Ò»£©

4. ¼ìË÷Ñ¡Ð޿γ̰üº¬1106ͬѧËùѧȫ²¿¿Î³ÌµÄѧÉúѧºÅºÍÐÕÃû¡£

5. ²éѯÿÃſγÌÖзÖÊý×î¸ßµÄѧÉúѧºÅºÍѧÉúÐÕÃû¡£

µÚ 12 Ò³ ¹² 12 Ò³

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)