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

• Next in forum: Re: MySQL - index optimisation - Any good resources?
• Prev in forum: Re: Large query results - Limiting the data, but still knowing the full row count - How?
• Thread view: MySQL - index optimisation - Any good resources?

[Reply to this message]