MySQL Forums
Forum List  »  Performance

indexing SET columns
Posted by: Haafiz Dossa
Date: December 11, 2004 01:12PM


I was doing some testing, and had a multi-column index created for a bunch of columns called "test1", and then i creaetd an indentical index called "test2" except it i took out the SET column. when i did an EXPLAIN SELECT query, it picked the "test2" index, when one of the WHERE conditions was (FIND_IN_SET("1", set_column)>0).

Is there a way to create the index on the table or is there a certain way to structure the SELECT query to use the index of the set_column?

Options: ReplyQuote

Written By
indexing SET columns
December 11, 2004 01:12PM
December 15, 2004 01:51PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.