As shown in the previous section, when you generate statistics for a temporary table, the statistics are visible only to…