On Tue, Jul 31, 2007 at 10:35:25AM +1200, adey wrote: > -- CAUTION: this query may impact system performance as you are selecting > from system tables
What difference are you expecting that to make and why?
It was a warning I received some years ago when I riginally discovered the query. Presumably reading from system tables competes with user queries for the system tables, slowing them down. I can't say I've ever noticed any impact when using it though.