On 7/31/07, Michael Fuhr <mike@xxxxxxxx> wrote:
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.
--
Michael Fuhr
