hello, I've a query that runs very slow: select name, count(id) where str_field = "some string" or (str_field > "string with nuber at end 1" and str_field < "string with nuber at end 9") group by name
i have about 4mil records and the query takes about 3 minutes str_field, name are MUL indexes both varchar(100) and id is a pk. is there a way to speed up the query? (the > and < then seemed to be pretty fast but adding "or str_field = 'some string'" made it really slow).