Êý¾Ý¿âʵÑ鱨¸æ£¨Ò»£©
µÚ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 Ò³