I think the difference I observed in my table was that as follows fields were listed as follows. The moment I changed the position of CATEGORY field to last field, it started to work.
1. CATEGORY
2. CODE //was indexed
3. NAME //was indexed.
4. PACK
5. UNIT