Re: order by view

Fernando Nunes wrote: > Andrew wrote: > >> I presume, if you put an ORDER BY in an Oracle view, and then the >> same ORDER BY in the SELECT on that view, the engine will be smart >> enough not to twice-order it? If so, understand this as a local >> optimisation that Oracle offers but not something that should allow >> you to lazily leave the ORDER BY clause off individual selects. > > Err... "twice re-order"?! > Everybody seems to forget (or I'm terribly mistaken) that a View DOES > NOT exist. It is just a "comodity". It is instantiated each time a > select is done. > > Unless of course we're talking about materialized views. I'm guessing, from a perspective of almost complete ignorance of Oracle, that this is the effect...