Document toolboxDocument toolbox

sp531_optimizer_statistics

Owned by Jason Andrew
Oct 02, 2024
2 min read

This table contains statistical information about the optimizer at specific points during an optimizer run. Each entry in the table contains statistics about the optimizer at a particular point.


Entries are only added to this table if the system parameter with value opt_stats_enabled is set to 'YES'.

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
optimizer_run_nonumber(1) (error)
statistics_nonumber(9) (error)
solution_typenumber(1) (error)
iteration_nonumber(6) (error)
rev_op_successnumber(9)  (error)
rev_op_triednumber(9) (error)
trav_op_successnumber(9) (error)
trav_op_triednumber(9) (error)
move_op_successnumber(9) (error)
move_op_triednumber(9) (error)
swap_op_successnumber(9) (error)
swap_op_triednumber(9) (error)
(plus)total_cost

number(19)

NB: This column will be represented as an int(8) in SQLServer implementations.

 (error)
blend_op_successnumber(9) (tick) 
blend_op_triednumber(9) (error)

Keys

primary key (optimizer_run_no, statistics_no) 
foreign key (optimizer_run_no) references sp530_optimizer_runs(optimizer_run_no) 
foreign key (solution_type) references sp533_optimizer_solution_types(solution_type)

Column Descriptions

FieldDescription
optimizer_run_no The optimizer run during which this writeback happened.
statistics_noServiceOptimizer-generated unique identifier (within this optimizer run). Identifies a unique point during an optimizer run.
solution_type Identifies the type of solution being reported (e.g. initial, interim or final).
iteration_noThe optimizer temperature step at which this solution was reported. 
rev_op_successCount of the number of REV operations that have succeeded so far within this optimizer run.
rev_op_triedCount of the number of REV operations that have been attempted so far within this optimizer run. 
trav_op_successCount of the number of TRAV operations that have succeeded so far within this optimizer run. 
trav_op_triedCount of the number of TRAV operations that have been attempted so far within this optimizer run. 
move_op_successCount of the number of MOVE operations that have succeeded so far within this optimizer run.
move_op_triedCount of the number of MOVE operations that have been attempted so far within this optimizer run. 
swap_op_successCount of the number of SWAP operations that have succeeded so far within this optimizer run. 
swap_op_triedCount of the number of SWAP operations that have been attempted so far within this optimizer run. 
total_costThe total cost of the schedule at this point in the optimizer run. 
blend_op_success Count of the number of BLEND operations that hace succeeded so far within this optimizer run.
blend_op_triedCount of the number of BLEND operations that have been attempted so far this optimizer run.