osCommerce Specials Query Optimization

Run this code in your specials table to create an index, dramatically increasing the time it takes to load any page that has a special price displayed on it:

create index IDXSPECIALSPRICE on specials (products_id,status,specials_new_products_price)

All credit goes to MontanaMan.