Re: Views

In article: <Kenneth.D.Atkins.13.2F775FEC_at_tek.com> Kenneth.D.Atkins_at_tek.com (Kenneth D Atkins) writes:
>
> I think that Oracle stores a 'Parsed' version of the view, so when you use the
> view, the SQL statement does not have to be parsed. If the Shared SQL area is
> working correctly, the non-view query should run as fast as the view query
> after the first time. You could also use tkprof to see how much of the 2.5
> seconds is 'Parse' time.
>
> This is just a guess, maybe someone who really knows the answer could reply.
>

        It is also a guess which is totally wrong, Oracle only stores the view text in the data dictionary.

---

	Tim L