How to get row count in Optimize way ? SQL_CALC_FOUND_ROWS is an option but is there any else?

Question

This is one way as i know . please suggest any other ???

SELECT SQL_CALC_FOUND_ROWS * FROM Table;

SELECT FOUND_ROWS();

Answer 1

You can use (it will be faster) :

SELECT COUNT(*) FROM Table