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 6Detection and Resolution of Query Performance Issues

Introduction

This chapter focuses on the detection and resolution of performance issues at the individual query level. Performance and tuning is a broad topic and could fill an entire book. This chapter, however, will focus on showplan messages and set option show query processor set commands. In pre-ASE 15 terms, set option show is utilized to display optimizer diagnostics. The detection and resolution of performance issues with some of the new features are explored. In particular, an emphasis is on diagnosing situations with incorrect partition strategies in an ASE server. Further, this chapter demonstrates the importance of proper partition strategy with examples on how to detect ...

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