speed this up?

From: Guang Mei <guangmei_at_yahoo.com>
Date: Wed, 22 Oct 2008 12:17:51 -0700 (PDT)
Message-ID: <147911.58924.qm@web39503.mail.mud.yahoo.com>


Oracle 10.2.0.1.0

I have a sql that is slow to run:

create table tmp_table nologging as
(select column1 from table1 where column2 > some_value having count(*) > 1 group by column1);

table1 is large, column2 has index on it. The count(*) value in the above query is quite big (typically in thousands) . Since I only need to check if the count(*) is large than 1, is there a way (say to use rownum somehow ) so that when count(*) gets up to 2, it stop counting (using stopkey), therefore I can have the above query run faster?

Thanks.
Guang       

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 22 2008 - 14:17:51 CDT

Original text of this message