Progressive Insurance interview question

Parameter sniffing, ETL techniques, SP optimization