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.