Re: Doing a select on a large table
limit 10000, 20000
will still read the first 10000 rows, but does not send them to the client, then read the next 20000 rows and send that to the client.
So, it will read a total of 30000 rows, but only send 20000 rows to the client.
Subject
Views
Written By
Posted
7533
September 07, 2006 02:04AM
3310
September 07, 2006 06:37AM
3321
September 18, 2006 01:58AM
Re: Doing a select on a large table
3301
September 18, 2006 07:00PM
3135
September 18, 2006 08:32PM
2943
October 05, 2006 02:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.