Currently, temp tables (/views/sequences) are experimental. This issues is be a "master issue" of things remaining to do before moving it off experimental.

Things to do:

• performance benchmarks (sql: performance testing for temp tables #46213)
• complete schema resolution caching which prevents slowdowns with new schemas in force
• move descriptors from gossiping all descriptors to only gossiping deltas

Enhancements

• potentially be in-memory by default
• smarts about locality in which they were created
• improve validations (sql: improve validation when dropping temp schemas #151553)

Testing

• add to DRT operations (roachtest/drt: add temp table usage to DRT #151545)

(feel free to edit, I couldn't find any more for the time being)

Jira issue: CRDB-5098

gz#22057