Re: Counting Rows
You may want to have an index on (feed_id,found_date) on articles table instead of (feed_id) only.
The count should not affect the performance by too much.
If still not good enough, you can try covering index.
index (feed_id,found_date,article_id) on articles table
index (member_id,feed_id,lastVisited_date) on feedRoll table
Subject
Views
Written By
Posted
1879
September 09, 2005 01:42PM
Re: Counting Rows
1328
September 09, 2005 03:52PM
1283
September 09, 2005 04:03PM
1172
September 09, 2005 04:05PM
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.