Document toolboxDocument toolbox

sp532_optimizer_costs

Owned by Jason Andrew
Oct 02, 2024
1 min read

This table contains a cost breakdown for the state of the schedule at certain points during an optimizer run. 


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(9) (error)
statistics_nonumber(9) (error)
cost_nonumber(3) (error)
basenumber(10) (error)
weightnumber(9) (error)
actualnumber(10) (error)

Keys

primary key (optimizer_run_no, statistics_no, cost_no) 
foreign key (optimizer_run_no, statistics_no) references sp531_optimizer_statistics(optimizer_run_no, statistics_no) 
foreign key (cost_no) references sp534_optimizer_cost_types(cost_no)

Column Descriptions

FieldDescription

optimizer_run_no,

statistics_no

Identifies the point in the optimisation at which these costs were assessed. 
cost_noIdentifies the type of cost being reported. 
baseUnweighted base cost. 
weightWeight applied to the base cost. 
actualActual cost.