Hi,If you have to choose which option do you implement, which one would you pick and why?. Please provide the main reasons. SQL 2008.Thanks in advance.--#1ALTER INDEX ON Table1 REBUILD;UPDATE STATISTICS Table1 WITH ALL; --FULLSCAN: option is used to specify all the rows in a table should be retrived to generate the key distribution statistics.--#2ALTER INDEX ON Table1 REBUILD;UPDATE STATISTICS Table1 WITH FULLSCAN; ------------------------------------------------------------------- -- Return when statistics were last updated?. SELECT CAST(OBJECT_NAME(object_id) AS VARCHAR(40)) AS 'TableName' ,CAST(name AS VARCHAR(40)) AS 'IndexName' ,STATS_DATE(object_id, stats_id) AS 'LastUpdateStatistics' FROM sys.stats WHERE ( object_id > 100 ) --Exclude systems. AND (name NOT LIKE '_WA%') ORDER BY 'LastUpdateStatistics' DESC, 'TableName' ASC; GO