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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.