I have two tables(table1 and table2), almost same structure exception adding index to field1 of table1, but table2's field1 is not index.
Field1 contains email address. When I use following command for table1, I couldn't select any data, only gave me empty.
"select * from table1 where field1="test@micrsoft.com";
The field1 of table1 is index.
But exact command apply for table2 like following, it works fine.
"select * from table2 where field1="test@micrsoft.com";
But I think that it would be good to have index in order to fast search or update later.
Any suggestions will be really appreciated.
