|
Posted by bozzzza@lycos.co.uk on 09/11/06 15:01
InfoSponge3000@gmail.com wrote:
> Sounds like you need a proper index for your query. I have tables with
> over 90 million rows that give subsecond query results because the
> indexes are optimized for the queries.
I have looked at the query execution plan, and 95% of the work is being
done in various indexes.
Though it looks like I will need to look at the query again ;-)
Navigation:
[Reply to this message]
|