Unused or Empty Table

This warning has been shown because the table is empty and has had no reads performed against it. This implies that the table isn't necessary, for whatever applications are run against the database.

⚠ This warning is purely based on SQL Server's statistics, which are only populated by querying of the database. If the database has just been restarted or restored, or it's a replica database that is never used for selects, then the statistics will not accurately represent whether the index is used or not.

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Investigate why the table hasn't been used and if it's referenced by any code. If not, consider dropping the unused, empty table.

How To Drop an Unused/Empty Table

DROP TABLE TableName;  

Further Reading

​DROP TABLE (Transact-SQL) | Microsoft Docs

sys.dm_db_index_usage_stats (Transact-SQL) | Microsoft Docs