> > > > >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