MySQL indexing tutorials

wxdqz

New Member
Hi,

I'm a MySQL newbie. After reading a couple tutorials online I decided to create my first database. Everything went fine, and it was fast, until I did left joined two other tables. This created 70 mb of tempfiles on the server, and my host wasn't happy to say the least.

Why don't they mention in the tutorials that it is very important to index tables ? Can I find any good tutorials on this?

Cheers, Aaron
 
Back
Top