Skip to Content
0
Jul 12, 2016 at 10:52 AM

3laks records in sql

20 Views

Hi,

i have a requirement to fetch the 3laks records from SQL server every day.

i written the select and update quires as

Select <filed_names> from Table_Name where flag = 0 and rownum<= 100

Update Table_Name set flag = 1 where flag = 0 and rownum<=100

is this quires correct, if yes per every 60 sec i will get 100 records and i can't fetch total records in24 hours.

can i increase the records as 300 then heap memory issue will rise.

please suggest how to fetch large data from SQL and with in min time.

Regards,

Nag