对于大数据行，哪个SQL语句在性能方面更好 [英] Which SQL Statement is better In Term of Performance in case fo large data rows

问题描述

哪个

SQL Statement is better In Term of Performance in case fo large data rows:-

(1)select col1,col2,col3,col4,col5 from <T.N>
               OR
(2)SELECT  * INTO  #tab1  FROM  (select col1,col2,col3,col4,col5 from <T.N>) AS a
SELECT *FROM #tab1
DROP TABLE #tab1

推荐答案

假设一个包含另一个，答案应该非常明显。



但是 - 这只是一个想法 - 你可以尝试一下并找出答案吗？这可能有所帮助： http://forums.asp.net/t/1793151.aspx/1 [ ^ ]

Given that one contains the other, the answer should be pretty obvious.

But - and this is just a thought - you could try it and find out? This might help: http://forums.asp.net/t/1793151.aspx/1[^]

这篇关于对于大数据行，哪个SQL语句在性能方面更好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！