more things done to improve sql

if force order hint is used - put left joins after inner joins
create indicies on temp tables after inserts