count in SQL count the number of row in a relation (table, query,…).
Database can use an index on a column to count the number of rows in the table only when the column has been declared NOT NULL