How to select max value faster from large size table I have query 

SELECT max(ParameterID) FROM modelparam_ems


Table Name: modelparam_ems

No Of Rows: 9000

It takes time to retrieve max value of parameterId, ParameterId in Unique value.

Output Time :

(Below row copied from Mysql Workbench).

13:51:15    SELECT max(ParameterID) FROM modelparam_ems 1 row(s) returned   0.109 sec / 0.000 sec
You have two options:


as TomBom Mentioned, you need to create an index on ParameterID column using this statement

create index idx_modelparam_ems_parameterid on modelparam_ems(ParameterID);

If your ParameterID column is AUTO_INCREMENT, 

you can get your max id by getting the next AUTO_INCREMENT value from the following query

SELECT AUTO_INCREMENT-1
FROM information_schema.tables
WHERE table_name = 'modelparam_ems'
AND table_schema = 'YourDBName' ;


If the engine is MyISAM and you are sure that there is no gap between two ids, you can find your max id by getting number of rows in the table as below. ROWS column contains the value for number of rows.

EXPLAIN SELECT * FROM modelparam_ems;


Note that In Innodb the value returned in rows is an estimation of total rows. So it is not as accurate as MyISAM.


Disclaimer 

Option 2 may be both unreliable, and subjected to failure. Use it only if option 1 is not possible and you can tolerate the failure.