运行的结果： 4.5秒左右：
Oracle执行
Set timing on; select * from dbo.total where companyname like '%武大%' 运行时间 18.5秒左右：
第二次多条语句搜索
SQL Server代码
declare @starttime as datetime; declare @endtime as datetime; set @starttime = getdate(); select * from dbo.total where companyinfo like '%华乐商务中心%' select * from dbo.total where companyinfo like '%联合国际%' select * from dbo.total where companyinfo like '%金丰大厦%' select * from dbo.total where companyinfo like '%光谷国际%' select * from dbo.total where companyinfo like '%国际商务大厦%' set @endtime = getdate(); select @starttime as 开始时间,@endtime as 结束时间,datediff(MS,@starttime,@endtime)as 运行时间
执行的时间与17秒左右
Sql/Plus命令中执行
执行的时间与39秒左右
Executed in 10.906 seconds
Executed in 5.078 seconds
Executed in 10.218 seconds
Executed in 10.218 seconds
Executed in 3.141 seconds
Executed in 5.078 seconds
Executed in 10.218 seconds
Executed in 10.218 seconds
Executed in 3.141 seconds
在进程中SQL Server 2005和Oracle占用内存 都是200M左右!
从结果可以看出50多万数据中SQL Server 2005明显速度优势大于Oracle 10g。
