Re: Views
From: Vincen5158 <vincen5158_at_aol.com>
Date: 24 Mar 1995 16:16:39 -0500
Message-ID: <3kvcrn$sjv_at_newsbf02.news.aol.com>
Date: 24 Mar 1995 16:16:39 -0500
Message-ID: <3kvcrn$sjv_at_newsbf02.news.aol.com>
> Both queries return 2 rows from the object_master table. It seems to me
that
> they are essentially the same query, except for the use of the view. If
anyone
> can tell me why the one executed using the view consistently runs more
than
> twice as fast as the other, I would be grateful.
Execute an explain plan on each query, this will tell you exactly what's
going on.
I'm an advocate for the use of views, but this is the first time I've
heard of a view running faster than a table query.
Are you using cost-based or rule-based optimization. Received on Fri Mar 24 1995 - 22:16:39 CET