mysql> EXPLAIN photos;
+-------------+-----------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------------+------+-----+------------+----------------+
| id | mediumint(8) unsigned | | PRI | NULL | auto_increment |
| description | text | | | | |
| data | mediumblob | YES | | NULL | |
| width | int(4) | YES | | NULL | |
| height | int(4) | YES | | NULL | |
| user_id | mediumint(8) unsigned | | MUL | 0 | |
| datum | date | | | 0000-00-00 | |
+-------------+-----------------------+------+-----+------------+----------------+
7 rows in set (0.02 sec)
die users-tabelle hat nur ca 200 datensätze.