MySQL retrieve method question.

[eluser]Unknown[/eluser]
[quote author="CroNiX" date="1330292865"]Because it will be found a lot faster if that key is indexed, and since you will be loading the entry by the slug name, it makes sense to index it for faster retrieval.[/quote]

[quote author="InsiteFX" date="1330293060"]KEY creates an index, which speeds it up.[/quote]

That explains a lot, thank you for the insight!