SQL optimizations in Oracle
From: Rishi Kumar <v_rishi_k_at_yahoo.com>
Date: 26 Aug 2004 21:11:44 -0700
Message-ID: <fd3b9393.0408262011.613cbdfe_at_posting.google.com>
consider the following queries that deals with report pagination
Date: 26 Aug 2004 21:11:44 -0700
Message-ID: <fd3b9393.0408262011.613cbdfe_at_posting.google.com>
consider the following queries that deals with report pagination
a ) select MYROWS.* from
(select * from TABLE_NAME) MY_ROWS where rownum between 1 and 100
b) select * from TABLE_NAME where rownum between 1 and 100
My question : Does oracle optimize the first query so that it is not significantly different (on execution time) when compared to the second query ?
Thanks
Rishi
Received on Fri Aug 27 2004 - 06:11:44 CEST