Howie

I have a database of 500 properties. A listing produces 30 properties per page (with no photo) is getting very slow to load. It produces a list returning properties betwen a price band for a specific country and sorted by price. I would like to improve performance. A Primary index is used. Is the Primary for one field or combination of fields. How do I use phpadmin to change? I do not understand how the primary / index / fulltext are set, and how they differ. Do I need to index on price, and country? Or Fulltext or change the Primary? I am a complete newbie on this - any help on the differences and how to set them in phpadmin much appreciated. :?: