>
>I think you are referring to Rushmore. How do I know that my code has been optimized (i.e. that the proper indexes have been set.

Check out SYS(3054).

>
>Also, I had another idea. This SQL gets executed 500 times. So every time do we have to go across the network? Maybe it'd speed it up if I copy all 3 files to 'local' version and use those? Note that right now, my .exe file is on the same network drive as the data.

It's rare to need to run the same query multiple times. It might be faster to pull all 500 cases into a cursor and then extract them one at a time with another query.

Tamar