Revision history [back]

Unfortunately, FINDINSET function cannot utilize indices in MySQL. This is because FINDINSET function is not a deterministic function, which means that it can return different results for the same input values. Therefore, MySQL does not allow the use of indexes on columns used in FINDINSET function. To improve performance, you may consider redesigning the table schema or using a different approach such as creating a separate table to store the sets and performing a JOIN operation.