判断sql执行效率以及针对临时表的使用

转载于 2015-04-08 17:11:00 发布 · 85 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/myblogslh/p/4402954.html

本文介绍了使用SQL Server Management Studio (SSMS) 进行查询优化的方法，包括选择性地查询特定数量的行、利用ID之间的范围查询以及将结果集导出到临时表并排序，以提高数据库查询性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/****** Script for SelectTopNRows command from SSMS  ******/

  
  
SET STATISTICS io ON
SET STATISTICS time ON
go
SELECT * FROM [TestPrint] WHERE ID IN (1,2,3,4,5,6,7,8,9,10);
go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF
go

SET STATISTICS io ON
SET STATISTICS time ON
go
SELECT * FROM [TestPrint] WHERE ID BETWEEN '1' AND '10';
go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF
go

select * into #tab from [TestPrint] where ID between '1' and '50000';
select * from #tab order by ID asc;
select name from tempdb.dbo.sysobjects where type='u' and name like '#%'
--truncate table ;(删除表)
go

转载于:https://www.cnblogs.com/myblogslh/p/4402954.html