> > 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])