>Michael;
>
>How big is your returned data set? How many records?
>
>Tom
30 records - Tamar told me about SYS(3054), and it pointed me to an index on the supplied table that screwed up uptimization. When I modified the query to use the same syntax as the index, that got everything going smoothly.
From 5 seconds down to .03 seconds.
Thanks
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site