Justin <[EMAIL PROTECTED]> writes: > Is there any plans in the future to add the ability for PostgreSQL to > create Ad Hoc indexes if it makes sense.
No, I'm not aware of anyone contemplating such a thing. I can hardly imagine a situation where building an index for a single query is actually a win. Maybe those DBMSes you mention were using this as a substitute for having decent join mechanisms, or something? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq