simple select query is taking a long time
793965Dec 13 2011 — edited Dec 13 2011hi gems...i have posted this question in database general section...because i thought it is a problem with the database and not with the plsql..
still i am posting it here...please take a look and help me...
my table has 7267563 rows...and i am doing a simple select * from table;
but it is taking a lot of time nearly 25minutes but not completed...
when i did select count(1) from table then it gave the result instantly..
also select * from table where rownum < 10 is also fine...
even when i am selecting all the records using rownum i.e. select * from table where rownum < 7267563 is also giving result instantly...
but the entire table is not getting result i.e. select * from table...
also there is no lock in the table(though i know that select is nothing to do with lock)..
not only a particular schema...in all schemas in that database i am experiencing the same problem...
the developers are complainning that database is very slow...for time being i requested them to use rownum condition...
please help..thanks in advance...