摘要:
今天有兄弟提到inner join,大表与小表的前后顺序会产生查询开销的差异,对此进行了如下测试:一, 创建测试表, t1, t2, t3-- create t1.CREATETABLE[dbo].[T1]( [UID][uniqueidentifier]NOTNULL, [Name][varchar](20) NULL, [Memo][varchar](20) NULL, CONSTRAINT[PK_T1]PRIMARYKEYCLUSTERED ( [UID]ASC)WITH (PAD_INDEX =OFF, STATISTICS_NORECOMPUTE =OFF, IGNORE_DUP.. 阅读全文
摘要:
Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]"别名"="DBMSSOCN,原始服务器地址,端口" 阅读全文