Hi Ross, > They will be expanded and presented as sub- > selects presumably, so that the DBMS can apply it's own analysis and > optimisations. Or is there another method in mind?
I'd suppose that there are cases where stored views have advantages, in that the engine can use optimizations it cannot do (or must re-do every time) for sub selects. Howeverm, this sounds too seldom to really base the decision on it. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
