On Wed, 15 Jan 2003, Roman Fail wrote:
> Thanks to everyone for the quick replies! I'm sure that my lack of
> skill with SQL queries is the main problem. What's strange to me is
> how MSSQL takes my bad queries and makes them look good anyway. It
> must have a real smart planner.
As a followup, if you do
set enable_indexscan=off;
before running the explain analyze, what does that give you?