Temporary databases implicitly use a durability of no_recovery. You may create temporary databases with an explicit no_recovery durability to enhance performance, and you may alter existing temporary databases to explicitly set their durability to no_recovery after upgrade.
Temporary databases that you use entirely in-memory explicitly use a durability of no_recovery.
Adaptive Server allows you to create and manage user-created tempdb groups in addition to managing the default tempdb group. User-created tempdb groups may include other user-created temporary databases, and support application and login binding.
You cannot remove the system tempdb from the default temporary database group. You cannot add system tempdb to any other user-created tempdb group.
Temporary database groups can mix disk-resident or in-memory temporary databases.
You can designate and administer user-created tempdb groups to contain only disk-resident or only in-memory temporary databases. Although Adaptive Server does not explicitly impose any restrictions, by controlling the membership to the tempdb groups, you can assign specific disk-only or in-memory-only tempdb groups to specific logins or applications.
