Very simple query hangs for minutes!!!

by Feb 20, 2014

Very often I have this problem: let's say I say SELECT * FROM MEMBER_TBL
and I get 20 rows back in a flash. Then I say SELECT * FROM MEMBER_TBL where MEM_NAME = 'Fred'
I sit there for like 2 minutes! Furthermore, if I copy the command and paste it into a new window it comes right back, usually before the original query returns. This happens EVERY day, what gives?!