Multiple choice technology databases

Which trace is useful for checking index selection by Sybase Optimiser

  1. 3604

  2. 2512

  3. 302

  4. 310

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Trace 302 in Sybase ASE displays detailed information about the optimizer's index selection process, including which indexes were considered and why they were chosen or rejected. This helps DBAs understand query performance and tune indexing strategies.