>
> >
> >The problem is not with SQL.
> >
> >LOCATE and SCAN are not optimizable anymore.
> >
> >Yes, SET OPTIMIZE is the default, which is ON.
>
> I have a table with 5,227,700 records and a tag on DELETED()
>
> I have performed a scan for operation in
>
> 2.6 Time was 8 seconds
>
> 5.0 Time was 12 seconds
>
> Does not seem to be a slow down here to me
>
> Am I doing it right?
That is 50 % slower or I _am_ missing something?
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.