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

SQLÓï¾äÖ´ÐÐЧÂʼ°ÐÔÄܲâÊÔ

д³ÌÐòµÄÈË£¬ÍùÍùÐèÒª·ÖÎöËùдµÄSQLÓï¾äÊÇ·ñÒѾ­ÓÅ»¯¹ýÁË£¬·þÎñÆ÷µÄÏìӦʱ¼äÓжà¿ì£¬Õâ¸öʱºò¾ÍÐèÒªÓõ½SQLµÄSTATISTICS״ֵ̬À´²é¿´ÁË¡£
    Í¨¹ýÉèÖÃSTATISTICSÎÒÃÇ¿ÉÒԲ鿴ִÐÐSQLʱµÄϵͳÇé¿ö¡£Ñ¡ÏîÓÐPROFILE£¬IO £¬TIME¡£½éÉÜÈçÏ£º
SET STATISTICS PROFILE ON£ºÏÔʾ·ÖÎö¡¢±àÒëºÍÖ´ÐвéѯËùÐèµÄʱ¼ä£¨ÒÔºÁÃëΪµ¥Î»£©¡£ 
SET STATISTICS IO ON£º±¨¸æÓëÓï¾äÄÚÒýÓõÄÿ¸ö±íµÄɨÃèÊý¡¢Âß¼­¶ÁÈ¡Êý£¨ÔÚ¸ßËÙ»º´æÖзÃÎʵÄÒ³Êý£©ºÍÎïÀí¶ÁÈ¡Êý£¨·ÃÎÊ´ÅÅ̵ĴÎÊý£©ÓйصÄÐÅÏ¢¡£ 
SET STATISTICS TIME ON£ºÏÔʾÿ¸ö²éѯִÐкóµÄ½á¹û¼¯£¬´ú±í²éѯִÐеÄÅäÖÃÎļþ¡£
    Ê¹Ó÷½·¨£º´ò¿ªSQL SERVER ²éѯ·ÖÎöÆ÷£¬ÊäÈëÒÔÏÂÓï¾ä£º
SET STATISTICS PROFILE ON 
SET STATISTICS IO ON 
SET STATISTICS TIME ON 
GO /*--ÄãµÄSQL½Å±¾¿ªÊ¼*/
SELECT [TestCase] from [TestCaseSelect] 
GO /*--ÄãµÄSQL½Å±¾½áÊø*/
SET STATISTICS PROFILE OFF 
SET STATISTICS IO OFF 
SET STATISTICS TIME OFF
    ÁíÍ⣬Ҳ¿ÉÒÔͨ¹ýÊÖ¹¤Ìí¼ÓÓï¾ä£¬¼ÆËãÖ´ÐÐʱ¼äÀ´²é¿´Ö´ÐÐÓï¾ä»¨·ÑÁ˵Äʱ¼ä£¬ÒÔÅжϸÃÌõSQLÓï¾äµÄЧÂÊÈçºÎ£º
declare @d datetime
set @d=getdate()
/*ÄãµÄSQL½Å±¾¿ªÊ¼*/
SELECT [TestCase] from [TestCaseSelect] 
/*ÄãµÄSQL½Å±¾½áÊø*/
select [Óï¾äÖ´Ðл¨·Ñʱ¼ä(ºÁÃë)]=datediff(ms,@d,getdate()) 
trackback: http://www.piaoyi.org/database/sql-statistics.html


Ïà¹ØÎĵµ£º

¾¡Á¿±ÜÃâÔÚSQLÓï¾äµÄWHERE×Ó¾äÖÐʹÓú¯Êý

----start
    ÔÚSQLÓï¾äµÄ WHERE ×Ó¾äÖÐÓ¦¸Ã¾¡Á¿±ÜÃâÔÚ×Ö¶ÎÉÏʹÓú¯Êý£¬ÒòΪÕâÑù×ö»áʹ¸Ã×Ö¶ÎÉϵÄË÷ÒýʧЧ£¬Ó°ÏìSQLÓï¾äµÄÐÔÄÜ¡£¼´Ê¹¸Ã×Ö¶ÎÉÏûÓÐË÷Òý£¬Ò²Ó¦¸Ã±ÜÃâÔÚ×Ö¶ÎÉÏʹÓú¯Êý¡£¿¼ÂÇÏÂÃæµÄÇé¿ö£º
CREATE TABLE USER
(
NAME VARCHAR(20) NOT NULL,---ÐÕÃû
REGISTERDATE TIMESTAMP---×¢² ......

sql ÈÕÆÚ±È½Ï

sql ºÜ¾Ã²»Óã¬Í»È»¼äÒªÇó×ö±¨±í¡£ËùÒÔÓÖ¿ÉÒÔ²¹Ò»²¹sql֪ʶÁË¡£µ«¾­³£»áÓöµ½Ò»Ð©ÈõÖÇÎÊÌâ.
дÁËÒ»Ìõsql£ºselect to_date('2009-09-24 12:20:0') Äܽ«¸Ä×Ö·û´®×ª»»ÎªÈÕÆÚ
µ«ÁíÍâÒ»Ìõsqlȴת»»²»ÁË...¸Ð¾õºÜÆæ¹Ö.ÓÚÊǺõ¡£ÔÙ×Ðϸ¿´Ò»±é ·¢ÏÖ
¸øÒ»¸öÈÕÆÚ×Ö¶ÎÉèÖñðÃûʱÉèÖóÉÁËsib.fbizDate as dateÎÒ×Ô¼º¶¼ÎÞÓïÁË¡£Ôõô»áÉè ......

×ªÔØ Sqlµ¼Èëµ½´¦Excel

/*=================== µ¼Èë/µ¼³ö Excel µÄ»ù±¾·½·¨ ===================*/
¡¡¡¡
¡¡¡¡´ÓExcelÎļþÖÐ,µ¼ÈëÊý¾Ýµ½SQLÊý¾Ý¿âÖÐ,ºÜ¼òµ¥,Ö±½ÓÓÃÏÂÃæµÄÓï¾ä:
¡¡¡¡
¡¡¡¡/*===================================================================*/
¡¡¡¡--Èç¹û½ÓÊÜÊý¾Ýµ¼ÈëµÄ±íÒѾ­´æÔÚ
¡¡¡¡insert into ±í select * from
¡¡ ......

SqlServer ²éѯsqlÖ´ÐÐʱ¼ä

ÔÚ²éѯ·ÖÎöÆ÷ÖÐÊäÈëÒÔÏÂÄÚÈÝ£º
set statistics profile on
set statistics io on
set statistics time on
go

go
set statistics profile off
set statistics io off
set statistics time off ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ