Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with 6,778,904 records and from that i need to take the maximum and minimum date. I used the following code. But it is taking more time to complete.
CalTemp:
LOAD
max(SERVICEDATE) as MaxDate,
min(SERVICEDATE) as MinDate
Resident COST;
I am loading the COST from a qvd file. Any idea on how to optimize this?
Thanks
Just what you need:
Yeah, it works perfectly. Thanks for the reference