Timeline for Index optimization
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 8, 2013 at 7:43 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
added 130 characters in body
|
| May 8, 2013 at 7:25 | comment | added | Michiel van Vaardegem |
No foreign keys in de posttag table?
|
|
| May 8, 2013 at 7:21 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
added 6 characters in body
|
| May 7, 2013 at 17:10 | comment | added | Peeyush Kushwaha |
could you explain how mysql works PRIMARY KEY postid (postid,tagid), UNIQUE KEY tagid (tagid,postid) ? As far as I know mysql concats both values for primary keys and stores that as index, so unless my query is somethin like SELECT * FROM table WHERE tagid = ?,postid = ?, it wont do me any good. will the primary key you suggest be much useful in JOINs?
|
|
| May 7, 2013 at 8:32 | history | edited | Cristian Porta | CC BY-SA 3.0 |
Updated infos as a suggested from @ypercube
|
| May 7, 2013 at 8:29 | comment | added | Cristian Porta |
@ypercube Ops... yes on (postid,tagid) :)
|
|
| May 7, 2013 at 8:14 | comment | added | ypercubeᵀᴹ |
No primary key for table posttags?
|
|
| May 7, 2013 at 6:16 | history | answered | Cristian Porta | CC BY-SA 3.0 |