Adaptive Server has a temporary database, tempdb. It provides a storage area for temporary tables and other temporary working storage needs. The space in tempdb is shared among all users of all databases on the server.
The default size of tempdb depends on the logical page size for your server, either 2, 4, 8, or 16K. Certain activities may make it necessary to increase the size of tempdb. The most common of these are:
Large temporary tables.
A lot of activity on temporary tables, which fills up the tempdb logs.
Large sorts or many simultaneous sorts. Subqueries and aggregates with group by also cause some activity in tempdb.
You can increase the size of tempdb with alter database. tempdb is initially created on the master device. Space can be added from the master device or from any other database device.
