怎么查看SQL语句的性能？

[rczjp]

在MYSQL 里面有条EXPLAIN SQL语句可以查看这条语句执行的一些信息，从而可以进行优化。想知道在SQL SERVER中有没有类似查看这条语句执行的性能信息，从而好对比，写出更加优化的语句！
另外有推荐SQL优化的书籍没有，谢谢！

[gw6328]

还可以
set statistics io on
set statistics time on
查看读取次数,cpu运行时间。

[rczjp]

谢谢大家，不过不是很会查看CTRL+L的数据

想请教大家下面这条语句怎么优化好呢

Select tmp.UserNumber From PRE_Follow Inner Join(Select UserNumber,Max(FollowTime) as TopFollowTime From PRE_Follow Where FollowState=1 Group By UserNumber)as tmp on PRE_Follow.UserNumber=tmp.UserNumber And PRE_Follow.FollowTime=tmp.TopFollowTime And FollowTime<=Convert(DateTime,GetDate())

[rczjp]

PRE_Follow表

CREATE TABLE [dbo].[PRE_Follow](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserNumber] [varchar](50) NOT NULL,
	[FollowState] [int] NOT NULL CONSTRAINT [DF_EZX_Follow_FollowState]  DEFAULT ((0)),
	[FollowUserName] [nvarchar](500) NOT NULL,
	[FollowContent] [ntext] NULL,
	[FollowTime] [smalldatetime] NULL,
	[AddTime] [smalldatetime] NOT NULL CONSTRAINT [DF_EZX_Follow_AddTime]  DEFAULT (getdate()),
 CONSTRAINT [PK_EZX_Follow] PRIMARY KEY CLUSTERED 
(
	[ID] ASC,
	[UserNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

[rczjp]

简单来说就是查询出这张表PRE_Follow中的FollowTime字段的最大时间小于今天 的所有用户号

[AcHerat]

CTRL+L看执行计划。或者看看执行的时间。

[發糞塗牆貮號]

SQL也有执行计划
ctrl+L
图形版的
或者
set showPlan_text on
或者
set showPlan_all on
或者
set showPlan_xml on

[mabailin]

图形界面写完语句直接 CTRL+L