Re: Calculating IX_SEL in 10053.

From: <mccmx_at_hotmail.com>
Date: 8 Jan 2007 01:24:06 -0800
Message-ID: <1168248246.175579.145290@42g2000cwt.googlegroups.com>

> Just one odd extra thought -
> If you create a simple query which is just
> the select statement, with constants, do
> the selectivity figures stay the same, or
> do they match my original formulae ?
>

Just tried that - the selectivities are still not clear cut.

I will have a play around with different constant values to see if I can spot where the calculations are coming from.

Thanks again for your time.

Matt Received on Mon Jan 08 2007 - 03:24:06 CST