On Fri, Oct 16, 2009 at 5:12 PM, miller_2555
wrote:
> [...snip...] attempted to set the `join_collapse_limit` to '1' [...]
That seems like an odd thing to do - why did you do this? What
happens if you don't?
I have never seen anything like the bizarrely large row estimates that
you have here.
Hi -
I'm stuck on a query performance issue, and I would sincerely appreciate
any server setting/ query improvement suggestions. I am attempting to
retrieve records stored in 20 tables that are related to a one or more
records in a single table (let's call the 20 tables `data tables` and the