>>Try setting ANSI and EXACT ON before the select, and remove the "==" and see what happens.
>
>SET EXACT has no effect on SQL commands and "==" is the same as SET ANSI ON.
I refer you to page 130 of Tamar's Taming SQL and the example of "Smith = S" and the effect of SET EXACT OFF, with SET EXACT OFF the results may not be what you expect.
With "==" vs SET ANSI ON, it appears to make a perceivable speed difference when using "==", especially with large files.
I have come to this conclusion after extensive testing with large files, and this combined with optimizing queries with the SYS(3054,12) clause you get amazing speed results i.e. extract 8K records from a 15Mil record file with a few joins in 0.36 secs.
Regards N Mc Donald