´óÊý¾ÝÁ¿Ï¿ìËÙ»ñÈ¡ SQL Server Êý¾Ý¿â±í¼Ç¼ÊýµÄ·½·¨
ÔÚÊý¾Ý¿âÓ¦ÓõÄÉè¼ÆÖУ¬ÎÒÃÇÍùÍù»áÐèÒª»ñȡijЩ±íµÄ¼Ç¼×ÜÊý£¬ÓÃÓÚÅжϱíµÄ¼Ç¼×ÜÊýÊÇ·ñ¹ý´ó£¬ÊÇ·ñÐèÒª±¸·ÝÊý¾ÝµÈ¡£ÎÒÃÇͨ³£µÄ×ö·¨ÊÇ£ºselect count(*) as c from tableA ¡£È»¶ø¶ÔÓڼǼÊý¾Þ´óµÄ±í£¬ÉÏÊö×ö·¨½«»á·Ç³£ºÄʱ¡£ÔÚDELL 4400 ·þÎñÆ÷ÉÏ×öÊÔÑ飬MS Sqlserver 2000 Êý¾Ý¿â¶ÔÓÚ100Íò¼Ç¼µÄ¼òµ¥Êý¾Ý±íÖ´ÐÐÉÏÊöÓï¾ä£¬Ê±¼äÔÚ1·ÖÖÓÒÔÉÏ¡£Èç¹ûÔÚ±íµÄij¸ö×Ö¶ÎÉÏ×ö¾Û´ØË÷Òý£¬µÚÒ»´ÎÖ´ÐиÃÓï¾äµÄʱ¼äºÍûÓÐË÷ÒýµÄʱ¼ä²î²»¶à£¬Ö®ºóÖ´ÐÐÉÏÊöÓï¾ä£¬ËٶȺܿ죬ÔÚ1ÃëÖÐÒÔÄÚ£¬µ«µ±±íµÄ¼Ç¼Êý·¢Éú½Ï´ó±ä»¯ºó£¬ÔÙÖ´ÐиÃÓï¾äÓÖ»á¾ÀúÒ»´ÎºÄʱµÄ¹ý³Ì¡£¶øÇÒ²»ÊÇÿ¸ö±í¶¼ÊʺÏ×ö¾Û´ØË÷ÒýµÄ£¬¶ÔÓÚÊýÁ¿¾Þ´óµÄ±í£¬Èç¹ûÐèÒª¾³£Ôöɾ²Ù×÷£¬½¨¾Û´ØË÷ÒýÊÇÒ»¸öºÜ²»Ã÷ÖǵÄ×ö·¨£¬½«»á¼«´óµÄÓ°ÏìÔöɾµÄËٶȡ£ÄÇôÓÐûÓÐÒ»¸ö±È½Ï¼òµ¥µÄ·½·¨¿ìËÙ»ñÈ¡±íµÄ¼Ç¼×ÜÊýÄØ£¿´ð°¸ÊÇÓеġ£
ÔÚMS SQL Êý¾Ý¿âÖÐÿ¸ö±í¶¼ÔÚsysindexes ϵͳ±íÖÐÓµÓÐÖÁÉÙÒ»Ìõ¼Ç¼£¬¸Ã¼Ç¼ÖеÄrows ×ֶλᶨʱ¼Ç¼±íµÄ¼Ç¼×ÜÊý¡£
ÏÂÃæÊÇsysindexes ±íµÄÏà¹Ø¼Ç¼µÄº¬Ò壺
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
id int ±íID(Èç¹û indid = 0 »ò255)¡£·ñÔòΪË÷ÒýËùÊô±íµÄID
Indid smallint Ë÷ÒýID£º
0£½±í
1£½¾Û´ØË÷Òý
>1£½·Ç¾Û´ØË÷Òý
255£½¾ßÓÐtext»òimageÊý¾ÝµÄ±íÌõÄ¿¡£
rows int »ùÓÚindid=0 ºÍ indid=1µØÊý¾Ý¼¶ÐÐÊý£¬¸ÃÖµ¶ÔÓÚindid>1ÖØ ¸´¡£Èç¹ûindid=255£¬rowsÉèÖÃΪ0¡£
µ±±íûÓо۴ØË÷Òýʱ£¬Indid = 0 ·ñÔòΪ 1¡£
ÄÇôÏÖÔÚ´ó¼ÒÓ¦¸ÃÖªµÀÈçºÎ»ñÈ¡±íµÄ¼Ç¼×ÜÊýÁË£¬Ö»ÐèÖ´ÐÐÈçÏÂÓï¾ä£º
select rows from sysindexes where id = object_id('tablename') and indid in (0,1)
¸Ã·½·¨»ñÈ¡±íµÄ¼Ç¼×ÜÊýµÄËٶȷdz£¿ì£¬ÔÚºÁÃ뼶¾Í¿ÉÒÔÍê³É£¬Ïà±Èselect count(*) Òª¿ìÉÏÊýÍò±¶£¬µ«ÊÇ´ó¼ÒÔÚÔËÓø÷½·¨ÊÇÒ»¶¨ÒªÖ÷Òª£¬¸Ã·½·¨µÃµ½µÄ±íµÄ×ܼǼÊý²»ÊÇÒ»¸ö¾«È·Öµ£¬ÔÒòÊÇMS SQL ²¢²»ÊÇʵʱ¸üиÃ×ֶεÄÖµ£¬¶øÊǶ¨Ê±¸üУ¬µ±´Óʵ¼ùÀ´¿´¸ÃÖµºÍ¾«È·ÖµÒ»°ãÎó²î²»´ó£¬Èç¹ûÄãÏ£Íû¿ìËٵĴÖÂÔ¹ÀËã±íµÄ´óС£¬½¨ÒéÄã²ÉÓø÷½·¨¡£Èç¹ûÄãÏ£ÍûµÃµ½¾«È·Öµ£¬ÄÇôÇëÔÚÖ´ÐÐÉÏÊöÓï¾äÇ°Ö´ÐÐDBCC UpdateUSAGE(DatabaseName,[TABLENAME]) WITH ROW_COUNTS Ç¿ÖƸüиÃ×ֶεÄÖµ£¬µ«ÕâÑùµÚÒ»´Î¸üÐÂʱ»áºÄ·Ñ´óÁ¿µÄʱ¼ä£¬ÕâÑù×öµÄЧ¹ûºÍ½¨Óо۴ØË÷ÒýµÄ±í select count (*) Ч¹ûÏà²î²»´ó£¬ËùÒÔÈç¹ûÄãÏ£ÍûÏà¶Ô¿ìËٵصõ½¾«È·µÄ±íµÄ¼Ç¼×ÜÊý£¬ÄÇôÄãÓÐÁ½ÖÖÑ¡Ôñ£¬½¨¾Û´ØË÷Òý»òÕßÏÈDBCC ÔÙʹÓÃÉÏÊö·½·¨
Ïà¹ØÎĵµ£º
--´Ë´¦Ê¹ÓÃpubs¿â
declare @myname varchar(50)
declare @fname varchar(20)
declare @lname varchar(20)
declare my_cursor cursor for
select fname,lname from employee order by emp_id
open my_cursor
fetch next from my_cursor into @fname,@lname
while @@fetch_status=0
begin
set @ ......
Ê×ÏȾÍÊÇÒª×Ô¼º±àдһ¶Î´úÂ룬´æΪ.stx
Îļþ£¨ÀýÈçsql.stx£©£¬È»ºóÔÚeditplusµÄ²Ëµ¥À¸Tools->Configure User
Tools->Files->Setting &syntax,µãadd°´Å¥£¬ÔÚdescriptionÀ¸Î»ÌîÉÏsql,file
ExtensionsÀ¸Î»Ò²ÌîÉÏsql,Èç¹ûÓжà¸öÀ©Õ¹Ãû£¬Ö®¼äÓÓ£»”¸ô¿ª£¨ÀýÈ磺sql;db2£©,È»ºóÔÚsyntax
fileÀ¸Î»ÌîÉ ......
Çå¿Õ¹²Ïí³Ø£¬¹Ø±Õ£¬ÖØÆôÊý¾Ý¿â
SQL> shutdown immediate;
SQL> startup;
¿ªÆô ʱ¼äͳ¼Æ
SQL> set timi on
SQL> select count(*) from dba_objects;
COUNT(*)
----------
11308
Elapsed: 00:00:00.19
SQL> /
COUNT(*)
----------
&nb ......
¡¡¡¡¶ÔÓÚOracleµÄµÚÈý·½¿ª·¢¹¤¾ß£¬±¾ÈËÖÓ°®ÓÚQuest SQL Navigator 5.5£¬ÒòΪËü·´Ó¦Ñ¸ËÙ¡¢Ö§³Ö¶à¸öÕ˺ÅͬʱµÇ¼£¬Æ½Ê±Ê¹ÓÃÆðÀ´ºÜ·½±ã¡£
¡¡¡¡²»¹ý£¬·¢ÏÖËüÓиöȱµã£¬¾ÍÊÇÒ»²éѯ´óµãµÄ±í£¬CPU¾ÍÕ¼ÓÃ50%ÒÔÉÏ£¬¸ãµ½Îҵı¾±¾¿ñ½Ð£¬ÎÒÕæÊܲ»ÁË¡£
¡¡¡¡µ½Ëü¹ÙÍø£¬·¢ÏÖÓÐа汾6.2ÁË£¬²»¹ýÏÂÔØҪע²áʲôµÄ£¬ÏÓÂé·³¡£
¡¡¡¡ÍíÉÏ£¬Í» ......