Cache tables are similar to MQTs with the restriction that a cache table supports only non-aggregate queries over a single table.
缓存表类似于具有以下限制的MQT，即缓存表只支持单个表上的非聚集查询。
A Web page displays the data, such as table-cache usage, key efficiency, connected clients, and temporary-table usage.
有一个Web页面会显示这些数据，例如表缓存的使用情况、关键字效率、连接上的客户机以及临时表的使用情况。
When a work table is dropped, two pages may remain allocated and they are returned to the work table cache.
工作表被删除后，这两页可能会保持分配状态并返回到工作表缓存中。
When a work table is cached, the table is truncated and nine pages remain in the cache for reuse.
缓存工作表时，该表会截断，并且缓存中保留九页以便重用。
Example 2: you have a "last_login" field in your table. It updates every time a user logs in to the website. But every update on a table causes the query cache for that table to be flushed.
例2：一家包括“最后登录”字段的用户表，用户每登录网站都会要更新，而每次对表的更新都会导致这个表的查询缓存要刷新。
Example 2: you have a "last_login" field in your table. It updates every time a user logs in to the website. But every update on a table causes the query cache for that table to be flushed.
例2：一家包括“最后登录”字段的用户表，用户每登录网站都会要更新，而每次对表的更新都会导致这个表的查询缓存要刷新。
应用推荐