Re: HOW 'VIEW' WORKS

Danny Roosens wrote:
>
> HI,
>
> I don't agree :
>
> optimistaion is different when the view is written completely or used as a view
> when joining with tables;
>
> Indexes on seperate tables are not taken as one would exspect (V7.2)
>
> --

Checked it out on V7.1 ... and you're right. Different Explain Plans when using a view vs when manually simulating the view in the select.

It appears that (in my test case) the kernel resolves the view first and then optimizes the rest.

/Hans Received on Wed Oct 02 1996 - 00:00:00 CEST