Temporary Table
Introduction This is a data storage mechanism used to solve the problem of temporary data storage. Although it is called a Temporary Table , this is actually a real table created in the database just like other normal tables. Characteristics The scope of existence of a Temporary Table is throughout that Session, until you disconnect. It is stored like a real table and can be written to disk if it exceeds temp_buffers. It has all the properties of a physical table, such as the ability to create indexes to speed up data queries, run ANALYZE or view the table structure. Its lifecycle only lasts throughout that Session, when you disconnect from the database, this temporary table will be automatically deleted, or you can also actively execute DROP TABLE. Because it exists throughout the session, it can be called for use multiple times in different statements and also within Functions or Stored Procedures. Use cases The following are appropriate cases to use a Temporary Table , including V...