Re: Cost based analyser and views

Volker Apelt <gq437x_at_yahoo.de> writes:

missing the joins to A, B and C.

> select
> A.group, A.no, B.no, d.field1, .. some other fields
> from
> v_across v,

    A        a, 


>   D        d,

>   B        b

    v.ID_A = A.ID_A and 
    v.ID_B = B.ID_B and 
    v.ID_D = B.ID_D and 


>   A.group = 3  and 

>   A.no    = 25 and 

-- 
Volker Apelt