Find Tables Without Indexes and Find Index Size of a Table

Question

Hi How can you find Tables without Indexes . How do you find Index size of a Table ?

Anil Kumar · Answer

And to find the size of a table try this : EXECUTE sp_spaceused My_Table_Name >

Anil Kumar · Answer

Try this: SELECT [name] AS Tables_Without_Indexes FROM sys . tables WHERE OBJECTPROPERTY ( OBJECT_ID  'IsIndexed' ) = 0 ORDER BY 1 ;

brunda k · Answer

exec sp_spaceused TableName http://sqlblog.com/blogs/davide_mauri/archive/2010/08/09/find-all-the-tables-with-no-indexes-at-all.aspx