Re: Optimizer problem?

From: Roger Snowden <rsnowden_at_supergeek.com>
Date: 1997/10/08
Message-ID: <01bcd41d$b2ec4520$096fc589@RSNOWDEN.labinterlink.com>#1/1

Are you using the cost-based optimizer? If so, did you analyze the table when you had it populated? If not, the server thinks the table is empty and so does a full table scan, since it would be cheaper. Or, if you have 'choose' set for optimizer option, lack of table stats will cause the rule optimizer to be used, which would mean a full scan unless you referenced an indexed column in the 'where' clause.

Roger

Phil Tsao <philt_at_technologist.com> wrote in article <343AD21D.4C94E1B_at_technologist.com>...
> Hi,
Received on Wed Oct 08 1997 - 00:00:00 CDT