indexing help

[davidstummer]

as i will have millions of rows in the following tables in mysql (oscommerce), i need to index them to make searches faster. what i am asking for is for someone to run through how to do this in phpmyadmin. the follwoing tables and rows are affected

 

products table

products_desciption table

products_to_catergories table

 

i really don't have a clue how to do this to make it faster

 

please can some really nice person help out

 

cheers

 

dave