Re: slow queries and blob fields
I was able to speed this query up with an index. I guess it's a composite index rather than a covering index if I'm understanding fully what you're saying here. I indexed on active,news_date and suddenly ALL the slow queries on this table sped up and dropped out of my slow_query_log! wow.
Explain, explained that indeed the various queries were using this index.
I've tried various covering indexes, composite indexes on my 3rd party tables but alas they did nothing so I removed them. sigh.
thanks for the info
On to other challenges!
Subject
Views
Written By
Posted
2699
July 06, 2005 11:09AM
1748
July 06, 2005 11:59AM
1661
July 06, 2005 06:05PM
1916
July 07, 2005 03:32PM
1661
July 07, 2005 05:58PM
Re: slow queries and blob fields
1766
July 12, 2005 10:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.