10g/9i: ORDER BY in view vs. ORDER BY in SELECT

Hi DBA's,

is there any difference in query plans if I do "order by" within a view or 
alternatively order my data in the select _on_ the view? 

My tests with 10gR2 did not show any difference in query plans with order by 
in view vs. order by in the select on the view.

Theoretically it's possible that using the "order by" in the select statement 
is more efficient, since it will order only the limited results, not the 
whole view result. But since the optimizer often does sophisticated things, I 
wondered if it will optimize the contrary case? I have not been able to find 
Oracle documentation on that special case. And if yes, how can I 
control/proof that behaviour in 10g and/or 9i?

Thanks a lot and best regards,
-- 
Freundliche Grüße

i.A.
Martin Klier
Systemadministration/Datenbanken
------------------------------------------------------------------
A.T.U Auto-Teile-Unger
Handels GmbH & Co. KG
Dr.-Kilian-Str. 4 
92637 Weiden i.d. OPf.

Tel.: +49 961 306-5663
Fax : +49 961 306-5982

[email protected]
www.atu.eu

Sitz: Weiden i. d. Opf., Amtsgericht Weiden i. d. OPf., HRA 2012
UST-ID Nr. DE814195392, WEEE-Nr. DE53789710
Persönlich haftende Gesellschafterin:
AFM Autofahrerfachmarkt Geschäftsführungs GmbH
Sitz: Weiden i. d. OPf., Amtsgericht Weiden i. d. OPf., HRB 2842
Geschäftsführer: Karsten Engel, Dirk Müller, Manfred Ries
------------------------------------------------------------------

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQBG1ns1VKZfihvnEcQRAq+NAKCsZsWDZ1NavCcIvfYF6PRBYx1LrQCfYlPH
TkXGJLUFT5DYtxg1WwhWpG0=
=h+8J
-----END PGP SIGNATURE-----