>
> Having picked out an index scan as being the highest time user I
> concentrated on that in this case and compared the same index scan on
> MSSQL. At least MSSQL reported it as an index scan on the same index
> for the same number of rows.
>
I should have also pointed out that MSSQL reported that same index scan as taking 65% of the overall query time.
It was just "faster". The overall query took 103ms in MSSQL.
Gary.