---- select count (*) from tableName;
This is the optimal choice when you face Mass Data;
---- select cout(*) from tableName where column = 'value';
This method is just so-so so-so. Its efficiency is low;
And the bad method is :
---- select count (column) from tableName;
We should try not to contact this method;
This is the optimal choice when you face Mass Data;
---- select cout(*) from tableName where column = 'value';
This method is just so-so so-so. Its efficiency is low;
And the bad method is :
---- select count (column) from tableName;
We should try not to contact this method;