Indexes are one of the most important factors in determining query performance. Luckily the code for determining which tables lack a valid index is relatively simple:
SELECT SCHEMA_NAME(schema_id) AS Schema,
name AS Table
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,’IsIndexed’) = 0
ORDER BY schema_name, table_name;
GO