Taking long time when finding max value of field

[Anonymous]

Hi all,

I have a table and is having around 200 million records. In that I am trying to get a max value of date filed in  table in load script and it is taking almost more than 1 hour of time to get max value of that field(field is date). Is there any way to reduce that much of time.

Thanks in advance.

Kumar

[sunny_talwar]

Sorry, but I am not sure I understand your post. Are you asking me a question?

[Anonymous]

No Sunny. We are taking that columns from Inserts table and using in  MinMaxDates: table. So is it rquired to use

Resident Inserts or not .

[sunny_talwar]

‌not required. Field value looks for a particular field from all tables. So you don't need to specify the table here. Autogenerate should work for you. give it a try and see if it works.

[Anonymous]

I will try it Sunny. You are giving such a wonderful replies with a patience.

[sunny_talwar]