Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics…