okay, I'm a bit confused:
http://dev.mysql.com/doc/refman/4.1/en/multiple-column-indexes.html
You see 2 examples at the bottom, where the name index is NOT used.
I understand why the index is not used in the first example, but why is
it not used for the "last_name" part in the query of the second example?
I think I need to revise my knowledge on indexing a bit :-/
--
==================================================================
Michiel Van Bel
PhD student
Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809
VIB Department of Plant Systems Biology, Ghent University
Technologiepark 927, 9052 Gent, BELGIUM
mibel(a)psb.vib-ugent.be http://www.psb.vib-ugent.behttp://bioinformatics.psb.ugent.be
==================================================================
friend of mine sent me this link yesterday:
http://www.youtube.com/watch?v=owGykVbfgUE
it's a good starting point for the entire youtube channel around this
guy. there are a couple more commercials and then a whoooooole lot of
"reply videos" in which he makes a youtube reply to comments posted
about him on twitter, youtube, reddit,...
shit's hilarious!
--
Marijn Vandevoorde
Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809
VIB Department of Plant Systems Biology, Ghent University
Technologiepark 927, 9052 Gent, BELGIUM
marijn.vandevoorde(a)psb.vib-ugent.be http://www.psb.vib-ugent.be
==================================================================
"Have you tried turning it off and on again?"
--Roy Trenneman
go to http://www.avs.be/
and click on "interactief"
so basically, you just have to go there, tell them what you want them to
do and then go back home and enjoy your interactive television!
--
Marijn Vandevoorde
Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809
VIB Department of Plant Systems Biology, Ghent University
Technologiepark 927, 9052 Gent, BELGIUM
marijn.vandevoorde(a)psb.vib-ugent.be http://www.psb.vib-ugent.be
==================================================================
"Stop! Hammer Time!"
--M.C. Hammer
