Re: View vs Underlying Query Performance Question

Soup wrote:
> Thanks for your response Martin.
>
> I removed the rownum and recreated the view as gpc_tp_query_vw2 and ran
> the following query.
>
> select * from gpc_tp_query_vw2 where userid = 'campbk2';
>
> The query is still slow. Any other thoughts?
>
> Here is the explain plan...
> (...)
>

Sorry. I'm really bad at interpreting xplans ...

If your question is still why using the view+predicate is slower than using the single statement, I'd suggest you make a post wherein we can find:

a) The query w/o view
b) The view definition
c) The query against the view
e) The differences btw the two explain plans

cheers,
Martin Received on Fri Sep 08 2006 - 15:46:23 CDT