Re: Optimizer problem

Make sure you run 'update statisitics' each time the table is reloaded. Regards, Rafal <101462.1654@compuserve.com> wrote: >Does anyone know of specific problems using On-Line 5.02 and using the >index optimizer to cause an application to use the index that is required. >We have an application that, each time we unload/reload tables or add an index causes >the program to go down the wrong index. >We are not updating the sys tables as when we tried this, we spent the next few days >modifying the code to suit. >Thanks for any info.