Article View: cn.bbs.comp.database
Article #461Re: ������С���ɣ���֪���Dz���old��
From: Galaxy��VOLUNTEERS��Database
Date: Sun, 05 Apr 2009 10:30
Date: Sun, 05 Apr 2009 10:30
35 lines
2580 bytes
2580 bytes
�Ҳ��Ե���SQL Serverʹ����Adventureworks���е�[Production].[Product]������
��������ظ����룬�����н�1ǧ������ݡ�û���������
������
DBCC DROPCLEANBUFFERS
dbcc freeproccache
DBCC FREESYSTEMCACHE ('ALL','default')
��������е�buffer��cache��
��ջ��棬���У�
SELECT * FROM [TestDB].[Production].[Product]
where 'Chainring' =LEFT([name],9)
���˺ܶ�Σ�����ʱ���1��06�뵽40�벻�ȣ������ü��β���ʱ�䶼���̶���
��ջ��棬����
SELECT * FROM [TestDB].[Production].[Product]
where LEFT([name],9) = 'Chainring'
���˺ܶ�Σ�����59�룬�������β��ԣ�����39��50�벻�ȣ�����ʱ��Ҳ���̶���
�һ���������ô���£����������ܿ��������������������ʮ��β�ѯ��sql server
�����������е��ڴ�����ˡ��������ˣ������ˡ�����
�� �� maxzsy ( ������) �Ĵ���
���ᵽ: ��
: ����������������˵����ѯ��ʱ�����ѱ��ʽ��������ڵȺ��ұߣ���ʼ�����ţ�����
: ������һ�£���Ķ��ٶ���Ӱ�졣�Ǻǣ���һ��10w����¼�ı?�����10%���ٶȰɡ���
: �Ҳ�֪���ģ��´ο������ԡ�
--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database
[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.156.69][m
Technical Details
Message-ID:
<4fIWiQ$bOY@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,6874027d33363118 X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: ������С���ɣ���֪���Dz���old�� Date: 05 Apr 2009 10:30:56 GMT Organization: ��ˮ˼Դ Message-ID: <4fIWiQ$bOY@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1238927450.A