Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Chapter 17: Using set showplan [Table of Contents] Chapter 19: Statistics Tables and Displaying Statistics with optdiag

Performance and Tuning Guide

[-] Chapter 18: Tuning with dbcc traceon

Chapter 18

Tuning with dbcc traceon

This chapter describes the output of the dbcc traceon(302, 310) diagnostic tools. These tools can be used for debugging problems with query optimization. This chapter contains the following sections:

[+] Tuning with dbcc traceon(302)
[+] The Table Information Block
[+] The Base Cost Block
[+] The Clause Block
[+] The Column Block
[+] The Index Selection Block
The Best Access Block
[+] dbcc traceon(310) and Final Query Plan Costs

showplan Messages for Subqueries [Table of Contents] Tuning with dbcc traceon(302)