how about normalizing the schema for start ?by the looks of it, you have huge table,with plenty of varchars, thatsmells like bad design of db.