Chapter 13Multiple Temporary Databases
Multiple temporary databases were first introduced in ASE 12.5.0.3. Due to the limited exposure offered on this subject and the impacts of ASE 15 on tempdb, this chapter addresses how multiple temporary databases may benefit your organization. This chapter answers the question “Why use multiple temporary databases?”
Introduction
Whether you are doing ad-hoc queries or full applications in ASE, the tempdb is an integral component of your environment. ASE-generated temporary worktables used for resolving order by and group by clauses are always created in tempdb. In addition, your application might create temporary tables in order to provide a facility to manage and make subsets of data available for improved ...
Get The Official New Features Guide to Sybase ASE 15 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
