Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select Statement

Re: Select Statement

From: eye1h <eye1h_at_yahoo.com>
Date: 21 Apr 2006 08:40:11 -0700
Message-ID: <1145634011.705330.91550@u72g2000cwu.googlegroups.com> 





Hi Steve,



My query had the SELECT COUNT(*) from tbl_name where condition and
rownum=1.


which went through all rows.



Upon looking at your one and changing it to
SELECT 1 from  tbl_name where condition and rownum=1 is fetches with
few rows in explain plan.



COUNT(*) was the culprint here.. I was not aware of this. Thank you
Received on Fri Apr 21 2006 - 10:40:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US