> 
> 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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to