select from a huge table

PLEASE HELP !!!!! I have a table about 7,000,000 records.

I get 12 records if I use "select * from mytable where f1 = 'ref1'";

but, my question is I need to use the following statement:

select c1.f1, c1.f2,c1.f3 from mytable c1, mytable c2 where c1.f1 = 'ref1' and c1.f2 <= ' c' and c1.f3 <> c2.f3;

I wait for 15 min, I still can not get the result, it is hanged there.

Any help will be appreciated. Many thanks. Received on Mon Dec 07 1998 - 14:48:33 CST