Ben Clewett <[EMAIL PROTECTED]> writes: > 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.
You can get the PostgreSQL query plan by issuing this query: EXPLAIN SELECT * FROM a WHERE f1 = 1 OR f2 = 1; The output from that command is what Dr. Hipp requested. Derrell