4 ms·
Try: SELECT COUNT(*) FROM (SELECT DISTINCT x FROM table) AS temp; The SELECT COUNT(DISTINCT x)) Is slow because it performs sort.
by takeda 11y ago
Try:
SELECT COUNT(*) FROM (SELECT DISTINCT x FROM table) AS temp;
The
SELECT COUNT(DISTINCT x))
Is slow because it performs sort.