How to Get Max field value of a large dataset without slowing down the workflow

[dgaines1972]

My issue is, I have a database table that contains a field [index number].  This table contains thousands of records and many other fields.  I need to get the max value of just [index number],   Presently, I am using a simple input tool (bringing in all fields and all records in the the table) followed by a  summarize on max value of [index number].  This method works, but it greatly slows down my overall workflow because it took so much processing power to read in the entire table.  Is there a faster way?  Thank you,

[binuacs · Accepted solution]

@dgaines1972 One option connect your database to the input tool and find the max of the index number using the SQL query 

[nagakavyasri]

@dgaines1972 You can sort the [index number] first and then use sample tool to get the maximum value.