Example Scripts for MySQL


The scripts provided in this appendix are ready to run and were tested on MySQL 5.1.

About the Author

Photo of Markus Winand
Markus Winand tunes developers for high SQL performance. He also published the book SQL Performance Explained and offers in-house training as well as remote coaching at http://winand.at/

?Recent questions at
Ask.Use-The-Index-Luke.com

0
votes
1
answer
92
views

PostgreSQL Bitmap Heap Scan on index is very slow but Index Only Scan is fast

22 hours ago Markus Winand ♦♦ 881
index postgresql postgres sql
3
votes
2
answers
362
views

pagination with nulls

2 days ago Rocky 46
pagination
0
votes
2
answers
82
views

Is it possible for PKs to change after Export -> Import?

Oct 29 at 09:21 KaiR 6
integrity mysql