TRUNCATE statement issued on a session-specific temporary table truncates data in its own session. It does not truncate the data of other sessions that are using the same table.

• 你可以索引临时表和在临时表基础上建立视图.；同样；建立在临时表上的索引也是临时的；也是只对当前会话或者事务有效