I have a table with a few 100K records. I have an index on column PiNumber - but when I run the following query in phpmyadmin it will run for
30+ minutes ...
But ... when I just do this simple query it runs in under a second
When i run show processlist, the query is stuck in state 'Sending data'