You shouldn't have to have an index for table with 500 records. There must be something going wrong with MySQL instance.
Yes, I do agree,. For now doing that fixed the problem.I am trying to get to the root cause,. Hopefully someday I might figure it out.. and update here.
You shouldn't have to have an index for table with 500 records. There must be something going wrong with MySQL instance.