ew, Special:Tags causes a filesort
No One
Actions

Authored By

	• demon
	Apr 12 2017, 7:10 PM

Size

879 B

Referenced Files

None

Subscribers

None

ew, Special:Tags causes a filesort
View Options

	mysql:wikiadmin@db1051 [enwiki]> EXPLAIN SELECT ct_tag,count(*) AS `hitcount` FROM `change_tag` GROUP BY ct_tag ORDER BY hitcount DESC;
	+------+-------------+------------+-------+---------------+--------+---------+------+----------+----------------------------------------------+
	\| id \| select_type \| table \| type \| possible_keys \| key \| key_len \| ref \| rows \| Extra \|
	+------+-------------+------------+-------+---------------+--------+---------+------+----------+----------------------------------------------+
	\| 1 \| SIMPLE \| change_tag \| index \| NULL \| ct_tag \| 272 \| NULL \| 24735709 \| Using index; Using temporary; Using filesort \|
	+------+-------------+------------+-------+---------------+--------+---------+------+----------+----------------------------------------------+
	1 row in set (0.00 sec)

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 4569315
Default Alt Text: ew, Special:Tags causes a filesort (879 B)

Event Timeline