Yup.
>Do you have a DELETED() tag on the table, and SET DELETED ON?
>
>And you are correct, a VIEW will not be of any help.
>
>>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!
>>
>>The table is linked to other applications maintained by the client, so I cannot make structural changes - but it seems like the indexes match the query.
>>
>>I'm sure I could tweak syntax a little, but I was wondering if I could speed things up by creating a VIEW instead. I suspect the answer is NO (what's a view, other than a remembered query, anyway). Please let me know if I'm wrong in my thinking.
>>
>>I figure I'll probably copy a subset of the data to a local table for faster initial display, and let it take the additional time needed for drill-down queries.
>>
>>Any other suggestions?
>>
>>TIA
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site