Thanks for your help.

Ian

"Tom Moreau" <tomdont.spam.me.cips.ca> wrote in message news:<uw4XrtJPDHA.2788TK2MSFTNGP10.phx.gbl>...
> The answer lies here:
>
> Table 'simple4'. Scan count 1, logical reads 0, physical reads 0,
> read-ahead reads 0.
> Table 'simple3'. Scan count 0, logical reads 0, physical reads 0,
> read-ahead reads 0.
>
> Notice the scan count for simple3. The table was not actually used.
> The partition elimination took place at run time.
>
> --
> Tom
> <snip>