Re: Behavior of indexes after run a CLRPFM

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

Are you sure you need an index? If the table is small enough, it may be
loaded in memory and an index is not required.
--Loyd
On Thu, Jan 20, 2011 at 10:17 AM, Rui Feliz <rmfeliz@xxxxxxxxx> wrote:

> Hi.
>
> Im working on AS/400. The only tool I know is PRTSQLINF. Anybody knows
> another?
> It's very strange, the index looks ok, but the optimizer don't uses it. In
> this situation, I drop the index and I create it again. After this, the
> index is used by the process.
> The only clue I have that perhaps causes problems is the CLRPFM  that I run
> in the beginnig of the process. The CLRPFM cleans the statistics of the
> indexes?
> Rui