The problem is that it is slow because of the number of records in the tables.
We are getting ready to upgrade to 10g and will have a lot of new capabilities available that we are not familiar with. Would a nested table or varray be appropriate for this type of thing? Would bulk collect apply? Or is there something else that we could use?
Your first step should be to improve the view's performance as much as possible using the features of your current Oracle version. It's hard to give specific advice without seeing the view definition. Once you've made response time as fast as you can, you can then consider, based on the most time-consuming operation in the view query, if a 10g enhancement can help. Take a look at this document for an overview of 10g's new features.
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.