October 2018
Beginner to intermediate
348 pages
10h
English
The TRACING command is a toggle that allows the tracing functionality to be turned on:
TRACING ONNow Tracing is enabledTRACINGTracing is currently enabled. Use TRACING OFF to disable
Tracing is useful in that it can show why particular queries may be running slowly. A tracing report allows you to view things about a query, such as the following:
Tracing will be covered in more detail in Chapter 5, Performance Tuning.