26 Aralık 2024 Perşembe

EXPLAIN FORMAT

Örnek
Şöyle yaparız
> EXPLAIN FORMAT=JSON INTO @myselect   SELECT name FROM a WHERE id = 2;
Query OK, 0 rows affected (0.00 sec)
> SELECT @myselect\G


Hiç yorum yok:

Yorum Gönder

LIMIT ve Covering Index + Subquery

Örnek Şöyle yaparız SELECT t1.name, t1.age, t1.gender, t1.create_time FROM student as t1    INNER JOIN     (SELECT id FROM student ORDER BY ...