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
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