On Mon, 2005-07-11 at 11:07 +0100, Ben Clewett wrote: > If you create a table with two indexes: > > CREATE TABLE a ( > f0 INTEGER PRIMARY KEY, > f1 INTEGER, > f2 INTEGER > ); > CREATE INDEX a_f1 ON a (f1); > CREATE INDEX a_f2 ON a (f2); > > Now execute a query using both the indexes: > > SELECT * FROM a WHERE f1 = 1 OR f2 = 1;
> 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. -- D. Richard Hipp <[EMAIL PROTECTED]>
