I am trying to use indexes on my tables to improve the performance.
The fields I have are: id, merchantname, Category, productName, Brand

I currently have the primary key as the id.
The...