开发者

Which is the most memory intensive SQL query: select, update or insert? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

Which is the most memory intensive SQL query: select, update or insert? and why?

The database consists of a two sim开发者_运维知识库ple tables that are independent of each other


This really depends on what is being requested in the query and the size of each table. A select all

SELECT * FROM Table

will consume whatever memory required to load records in that table.


Hard to say anything without knowing the actual statements but selects, especially joins and resultsets with many records are probably use more memory

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜