@Executions float = 504,

@Density float = 0.002267574,

@IndexDataPages float = 201,

@Cardinality float = 113443;

@SeqIO float = 0.000740740740741,

@RandomIO float = 0.003125,

@CPUbase float = 0.000157,

@CPUrow float = 0.0000011;

@IndexPages float = CEILING(@IndexDataPages * @Density),

@Rows float = @Cardinality * @Density,

@Rebinds float = @Executions - 1e0;

@CPU float = @CPUbase + (@Rows * @CPUrow),

@IO float = @RandomIO + (@SeqIO * (@IndexPages - 1e0)),

-- sample with replacement

@PSWR float = @IndexDataPages * (1e0 - POWER(1e0 - (1e0 / @IndexDataPages), @Rebinds));

@InitialCost float = @RandomIO + @CPUbase + @CPUrow,

@RebindCPU float = @Rebinds * (1e0 * @CPUbase + @CPUrow),

@RebindIO float = (1e0 / @Rows) * ((@PSWR - 1e0) * @IO);

SELECT

OpCost = @InitialCost + @RebindCPU + @RebindIO;