Table Definition

Field	Type	Default	Nullable
optimizer_run_no	number(9)
statistics_no	number(9)
cost_no	number(3)
base	number(10)
weight	number(9)
actual	number(10)

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

Field	Description
optimizer_run_no, statistics_no	Identifies the point in the optimisation at which these costs were assessed.
cost_no	Identifies the type of cost being reported.
base	Unweighted base cost.
weight	Weight applied to the base cost.
actual	Actual cost.

Browser not supported