Unfortunately, without seeing the the DDL for the view and the underlying table(s) and their indexes, plus how the view is being called I don't see how much more we can actually do to help. Anything we provide at this point will be nothing more than shots in the dark.