Simple Select Statement on MySQL Database Hanging
- by AlishahNovin
I have a very simple sql select statement on a very large table, that is non-normalized. (Not my design at all, I'm just trying to optimize while simultaneously trying to convince the owners of a redesign)
Basically, the statement is like this:
SELECT FirstName, LastName, FullName, State FROM Activity Where (FirstName=@name OR LastName=@name OR…