Multiple choice technology

There is no need to run “Generate statistics” if JIT stats are available on that table

  1. True

  2. False

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

JIT statistics are limited and collected incrementally during query execution. Running Generate statistics provides comprehensive table statistics that cover all columns and give the optimizer complete information. Both types serve different purposes - JIT for immediate optimization and Generate for complete analysis.