: SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y > 0) b WHERE (a.x : / b.y) > 1; How much of a performance hit is there when using a select in the FROM clause? Is it even noticeable? How much better is it to create a static view? -Dan
- [GENERAL] order of clauses Patrick Welche
- Re: [GENERAL] order of clauses Stephan Szabo
- Re: [GENERAL] order of clauses Michael Fork
- Re: [GENERAL] order of clauses Dan Wilson
- Re: [GENERAL] order of clauses Tom Lane
- Re: [GENERAL] order of clauses Steve Wolfe
- [GENERAL] Re: order of clauses Mitch Vincent