Re: Very slow query

[Rick James]

I agree with
index(collectionsearchterm,dateutc)

However, since you are in a Stored Procedure, I worry that the optimizer may not 'do the right thing'. Please run the EXPLAIN from within the SP.

Also, to verify what it is doing, collect
SHOW STATUS LIKE 'Handler%';
before and after the SELECT. Then diff the values. That will tell us whether it is really using the second part of the INDEX.