Rick Emery wrote: > > First: I believe this is not legal (looking at myySQL manual p 6.5.3): > PRIMARY KEY (key1), KEY (key2) > You may use one or the other.
yup, it does work here, ver 3.23.42. > Second: You may search by either owner_id or customer_id without creating an > index. > Such as: SELECT * FROM mytable WHERE owner_id=123; i know, perhaps i wasn't very clear. i want to do it in the fastest way possible, so i was wondering what was the correct key definition. cheers, f.- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php