Is in the database query table, that is, select the table is temporarily stored in memory? Also a great god, please give reply in time! Thank you very much!

CodePudding user response:

Select only the results returned to the client, specific see the client is how to deal with, it doesn't matter is not specified INTO and table

CodePudding user response:

Won't be stored in memory,
Can save the execution plan,

Example:
For the first time to drive to guangzhou, look at a map navigation time
A second time they go to, don't have to look at a map, but not on behalf of the oil