Re: slow queries and blob fields
To get a covering index, the first thing you need to do is to remove the select * and select only the columns you required, then add all these columns into a single composite index after (active,news_date, ...) then it will be a covering index.
Subject
Views
Written By
Posted
2695
July 06, 2005 11:09AM
1742
July 06, 2005 11:59AM
1658
July 06, 2005 06:05PM
1913
July 07, 2005 03:32PM
Re: slow queries and blob fields
1657
July 07, 2005 05:58PM
1763
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.