Re: Sequence vs. Index Scan

On Sat, May 05, 2007 at 04:05:52PM -0500, Aaron Bono wrote:
> I have two schemas, both with the exact same DDL.  One performs great and

Do they have the same data?

>  I have
> checked and there IS an index, specifically a primary key index, on the
> branch_id in both schemas so I cannot figure out why the optimizer is
> looking at these differently.  In fact, the table the branch_id comes from
> has the exact same indices and foreign keys on both schemas.

Different data?  Different statistics?  Different numbers of
(possibly dead) rows?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.    --Jane Jacobs