Sql Server, Query Optimization.
STATISTICS Employee; FULLSCAN option — You can perform a full scan of the table when updating statistics by using the FULLSCAN option. This option can be particularly useful when the table has undergone significant changes: UPDATE STATISTICS table_or_index_name WITH FULLSCAN; Execution Plans SQL