AHA! Thanks loads, Tamar! I found that their existing indexes were defined a little differently, thanks to you and SYS(3054). From 5 secs down to 0.03 secs - quite acceptable!
Michael
>>My query to a 300,000+ record table is taking too long for my app (5 sec) - especially since when it's published it'll be pulling the table from another machine so it'll be even slower!
>>
>>Any other suggestions?
>>
>
>Have you tried using SYS(3054) to find out whether the query is fully optimized?
>
>Tamar
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site