On Fri, Apr 13, 2012 at 8:40 PM, <mboldi(at)prospectiv(dot)com> wrote:
> I am doing a large query so I limit the query to 5500000 but I get 88 rows
> returned. I increase this to 9000000 and get 136 rows returned ..
> explain Plan ...
Please send the query with and without the LIMIT.
It might also help to send more such as the schema and possibly even
the data if that's possible. But at least send the queries so we can
see what you're doing. The plan does not look correct for what you've
described.
--
greg