問題描述
我需要執(zhí)行 16 個查詢.所有這些查詢都具有相同的格式:
I've 16 queries that I need to execute. All these queries have the same format :
SELECT string, number, number
將所有這些數(shù)據(jù)組合在一起對我來說很有意義，因為它可以創(chuàng)建一個包含所有結(jié)果的儀表板.
Make sense for me to group all these data together as it's to create a dashboard with all the results.
我的問題是:你認為 UNION ALL 會比一個一個執(zhí)行所有查詢更快嗎?
My question is : do you think a UNION ALL will be faster then executing all the queries one by one?
推薦答案
UNION ALL 當(dāng)然應(yīng)該讓你更快取回數(shù)據(jù).
UNION ALL should certainly allow you to get the data back faster.
不過，您打算如何處理客戶端上的數(shù)據(jù)?如果您必須將其拆分回 16 組獨立的數(shù)據(jù)集，則整體執(zhí)行時間可能會增加.
What are you going to do with the data on the client, though? If you have to split it back it into 16 separate sets of data the overall execution time will probably increase.
無論您做什么，您只需要對數(shù)據(jù)庫進行一次調(diào)用，因此如果您將其保留為 16 個單獨的查詢，那么最好在一個 存儲過程(或子存儲過程)中調(diào)用它們程序).
Whatever you do, you only want one call to the database so if you leave it as 16 separate queries then it would be nice to have them all called in one stored procedure (or sub-stored procedures).
這篇關(guān)于SQL Server:多個查詢或 UNION的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！