Report question

Question: SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes