>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