search

saykaren / TypescriptCheatSheet

0 stars 0 forks source link

SQL Optimize #432

Open saykaren opened 1 year ago

saykaren commented 1 year ago

EXPLAIN SELECT OR EXPLAIN FORMAT=JSON SELECT

Or in mysql workbench go to results and on right hand see under query stats the execution plan

saykaren commented 1 year ago

filtered want to see 100

saykaren commented 1 year ago

Access types

best to worst

saykaren commented 1 year ago

https://www.youtube.com/watch?v=EEklkdkuSfM