completes instantly. However, I feel
like I should find the heart of the problem, since bad statistics could
end up affecting other plans, right?
- Mike
On Mon, 7 Mar 2005 23:03:43 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Mon, 7 Mar 2005, Michael McFarland wrote:
I&
I'm trying to understand why a particular query is slow, and it seems
like the optimizer is choosing a strange plan. See this summary:
* I have a large table, with an index on the primary key 'id' and on a
field 'foo'.
select count(*) from foo;
1,000,000
select count(*) from foo where bar =
