Posted by cluthz on 06/13/07 13:27

I have recently had some corruption in my database of my php/ mysql
application. I have made some changed to my application that meant I did a
lot more larger queries.

I'm thinking I can write better SQL code to query my database and also make
sure my index's are in the right places.

Generally I put an index whenever I have a foreign key. But I want to be
able to learn if this is the best thing to do and how to use them better.

I have been unable to find any good resources on indexes that teach me
better. Even the MySQL book I have only seems to touch on them really.

Any help?

Thanks

[Back to original message]