>
>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?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
