>Not dreaming. You said it yourself. You never did figure out why. Someone also suggested the ODBC driver may have "converted" the queries in some way that made them more optimizable, but the anecdotal evidence you provide isn't enough to conclude that just using ODBC will beat local views.
>
True. But those are the results I got. This phenomenom is also documented in one of Hentzenwereke's books.