Unlike volatile tables, the performance of input and update due to the maintenance of disk data images is low, making them unsuitable for tables for real-time data representation such as dashboards.
Again, unlike volatile tables, the structure (schema) information in the lookup table is retained even after the server is restarted. You must explicitly use
DROP TABLE to drop the table .
Unlike the volatile table, the lookup table is restored to its original state when the server is restarted.Providing Index
Like the volatile table, it provides a RED-BLACK index. Therefore, it can be efficiently used in the search process or the join process with the log table.