Hi list,
as the doc says:
SELECT name FROM test2 WHERE major = constant AND minor = constant;
then it might be appropriate to define an index on the columns major and minor
together, e.g.:
CREATE INDEX test2_mm_idx ON test2 (major, minor);
I may ask a dumb question, but does the query planner also use such an
index with the inversed query, e.g.:
SELECT name FROM test2 WHERE minor = constant AND major = constant;
or am I obliged to define an inversed index?
JY
--
Everybody is going somewhere!! It's probably a garage sale or a
disaster Movie!!