Paste P5259

ew, Special:Tags causes a filesort
ActivePublic
Actions

Authored by • demon on Apr 12 2017, 7:10 PM.

Tags

None

Referenced Files

	F7511307: ew, Special:Tags causes a filesort
	Apr 12 2017, 7:10 PM

Subscribers

None

	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)

Event Timeline

• demon created this paste.Apr 12 2017, 7:10 PM

Salgo60 mentioned this in T202219: Sveriges Släkforskare: Anbytarforum linking P6303.Sep 11 2018, 3:21 AM