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.
2
solved Which is the most memory intensive SQL query: select, update or insert? [closed]