they add an index the productID columns of the ps3_productcategories and ps3_productoptions tables.
Those two columns create the relations to the products table. Adding an index to relational columns makes it easier for the database to perform queries where it needs to get data from both tables.
you should not need to run the queries again, once the index is created, it is a permanent change.