Fastest way of finding max/min values of a field in Sense or QV

sense_find_max_value_of_field

// The obvious way of finding the max/min value of a field might something like this:
//
// LOAD max(salesDate) Resident dataTable;
//
// However, if dataTable is very large (hundred of millions of lines or more, with many columns), the above will be  
// very slow, as we will end up traversing that entire table. 
//
// Instead, the fastest method of achieving the desired result is to load the FieldValue()s.
// We then only look at the values of the salesDate field itself, and not the entire dataTable table. 
// Performance gains by many orders of magnitude can be gained by using this method.
// 
LOAD max(FieldValue('salesDate', recno())) 
AUTOGENERATE FieldValueCount('salesDate');