UPDATE _STATISTICS is used to update the information used by indexes such as the distribution of key values for one or more statistic groups in the mentioned indexed view or table. SCOPE_IDENTITY is used to create identity value for tables in the current execution scope.