To avoid performance concerns that result from using a single temporary databases, you can create multiple temporary databases.
Adaptive Server includes one system-created temporary database called tempdb, which is created on the master device when you install Adaptive Server.
In addition to tempdb, Adaptive Server allows users to create multiple temporary databases. User-created temporary databases are similar to the system tempdb: they are used primarily to create temporary objects, and are recreated instead of recovered during start-up. Unlike tempdb, you can drop user-created temporary databases.
Multiple temporary databases:
Reduce contention on system catalogs and log files in the system tempdb
Can be created on fast access devices
Can be created or dropped as needed.
