Zeitwaechter/00-mysql-notes.md

Created May 11, 2020 08:11

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Zeitwaechter/0c9e198cd0e2a2008e7dd3d5608ad073.js"></script>
Save Zeitwaechter/0c9e198cd0e2a2008e7dd3d5608ad073 to your computer and use it in GitHub Desktop.

LaraCon 2018 - Addendum

Raw

Taken from Kai Sassnowskis' talk at LARACON EU from 2018 source:

Indeces aren't used when using functions (like e.G. YEAR() or MONTH()), use e.G. BETWEEN instead.
If not sure what is happening, use an EXPLAIN before your statement.
Multi column indeces go from left to right and you can not skip columns, so the defined order in the index matters.
An index and a query always have to go together.
Inequality Operators: Which query is more important? Is the introduction of another index the right approach?
"Indexing is my concern", not of others

Select an option