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.
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.
