To My understanding from the above posts, You are seeing a slow response . That means your query is slow, why don't you try how your query is waiting ... like checking v$session_wait and if possible you can use function based indexes, if necessary.. and also if this query is getting executed frequently( if this one is a literal SQL) , PIN it.. there will be no reparsing ..


Personally , if i want to have more refined data which will be queried later by a front end application , and i would go for a MView too