Which is the most memory intensive SQL query: select, update or insert? [closed]
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
精彩评论