D. Richard Hipp wrote:
MySQL and PostgreSQL will use the indexes here, and therefore return the result considerably faster.Really? I would be very interested to know what query plan MySQL and PostgreSQL use in this example.
It looks like I didn't look before leaping. MySQL does do a sequential search through all rows in table with same example.
But PostgreSQL does use indexes for the same example. Regards, Ben.
