Problem with performance!
Hello! Could anybody help me!!! How to make my SQL quicker: SELECT * FROM tablex WHERE field1 MATCHES '[K,k][O,o][P,p]*' Index is made by field1, table contains 34500 records, sql working 30 seconds. Is that normal? Marko
Hello! Could anybody help me!!! How to make my SQL quicker: SELECT * FROM tablex WHERE field1 MATCHES '[K,k][O,o][P,p]*' Index is made by field1, table contains 34500 records, sql working 30 seconds. Is that normal? Marko