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 5Overview of Changes to the Query Processing Engine

This chapter provides an overview of the changes to the query processing engine. The chapter discusses optimization goals, and outlines how to set them at the server, session, and query levels. It briefly describes the optimization criteria. Next, the chapter discusses the optimizer’s new “timeout limit” feature and shows how and why to limit the time the optimizer may spend on a particular query plan. Finally, the chapter provides examples of the types of queries that have benefited from the changes made to the Query Optimizer.

The Graphical Plan Viewer and the new set options to display the tree are discussed in Chapter 10.

Introduction

Queries used for OLTP (online transaction processing) ...

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