O'Reilly logo

The Official New Features Guide to Sybase ASE 15 by Carrie King Taylor, Steve Bradley, Naresh Adurty, Brian Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required