Hello all..

Oracle 92/Sun 5.8

I have 2 queries, that retreive data from the same table.

1) Query1 : It retreives about 100kb of data.
2) Query2: It retreives about 1MB of data.

Query 2 is taing ages to get the data. Its taking almost 10 minutes while query 1 takes about 2 sec.

any suggestions on what i need to look into ?...

Thanks
Ron