Matthew Wakeling <matthew(at)flymine(dot)org> wrote:
> any other tips?
I would try adding an index on (objectid, start) and another on
(objectid, end) and see how that first query does. Also, if id is a
unique identifier, I'd recommend a unique constraint or (better) a
primary key definition. Check the system tables to see whether all
the existing indexes are actually being used -- if not, drop them.
-Kevin