Document toolboxDocument toolbox

14.1 sp531_optimizer_statistics

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

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.