> >> Assume the following: > >> index on: (id, adate) > >> constraint CHECK(adate > '01-01-2007' AND adate < '04-01-2007'); > >
Um, the subject is CE, but the question is about an index ? Those are separate issues. > >> The planner will not use the index listed above. > > For what? > > select adate from parent where adate = '01-25-2007' A possibly cheaper plan would be a self join to produce all possible id's and join the index for each (id, adate) pair. Note, that you need not check visibility of the id's you produce (index only access). Is that what you were expecting ? This is not implemented. Andreas ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster