The Official New Features Guide to Sybase ASE 15

Description

This book focuses on the many enhancements in Sybase ASE 15 including system administration enhancements, functionbased indexes, computed columns, scrollable cursors, galaxy optimizer, query plan, galaxy partitions, multiple tempdb, MDA tables, andn Plan Viewer. Table of Contents 1 Exploring the Sybase galaxy 3 2 System maintenance improvements 13 3 Semantic partitions and very large database (VLDB) support 53 4 Scrollable cursors 145 5 Overview of changes to the query processing engine 167 6 Detection and resolution of query performance issues 187 7 Computed columns 225 8 Functional indexes 241 9 Capturing query processing metrics 261 10 Graphical plan viewer 287 11 Sybase software asset management (SySAM) 2.0 297 12 Installation of ASE servers 323 13 Multiple temporary databases 359 14 The MDA tables 373 15 Java, XML, and Web services in ASE 395 App. A Sybase ASE 15 certification sample questions and answers 417