indexing SET columns
Hello,
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?
Subject
Views
Written By
Posted
indexing SET columns
3204
December 11, 2004 01:12PM
1939
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.