Performance
I have a large historical db with approximately 10 million rows at this time. I need to query subsets of this data and am experiencing performance issues. Can anyone tell me what the best approach would be:
1. Standard SQL Select with an index on the where clause column
2. Create a view of the data I want to look at.
3. Create a separate table of these values and query that.
I can limit the access to the past 14 days, so a table with a FILO strategy would be attractive.
Subject
Views
Written By
Posted
3661
July 05, 2006 12:21PM
1686
July 05, 2006 05:42PM
1639
July 06, 2006 09:16AM
Performance
1837
July 14, 2006 12:07PM
1634
July 19, 2006 01:27AM
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.