"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes: > I have a view that when used, is slow:
It's obvious that you haven't given us anything remotely like full information here. AFAICT the "tables" in your view are actually other views, plus it looks like your call to the view is a query that adds some other conditions you didn't mention. (Or are those conditions coming from the sub-views? Hard to tell.) If you want useful help you need to be more complete. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]