Re: slow joining very large table to smaller ones

On Thu, Jul 14, 2005 at 04:29:58PM -0600, Dan Harris wrote:
>Ok, I tried this one.  My ssh keeps getting cut off by a router
>somewhere between me and the server due to inactivity timeouts, so
>all I know is that both the select and explain analyze are taking
>over an hour to run.

Try running the query as a script with nohup & redirect the output to a
file.

Mike Stone