From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > Sets result in table scans if they're the only condition in WHERE > clause. Until MySQL has a way of indexes them, you're stuck.
Thanx Jeremy! We've just found another reason (specifics about the data we wanted to store in the sets have just been released) for not using SETs in this case. At the moment for our purpose SETs are as (in)efficient as using LIKE '%text%' on a VARCHAR :-( Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
