Finding the Size of INDEX on Specific TABLE in SQL SERVER
use Northwind
SELECT object_name(object_id) as TableName, *
FROM sys.indexes
--Syntax
exec sp_spaceused 'TableName'
-- Check the
size of index
exec sp_spaceused 'Employees'
Thanks:)
Loading
Finding the Size of INDEX on Specific TABLE in SQL SERVER
use Northwind
SELECT object_name(object_id) as TableName, *
FROM sys.indexes
--Syntax
exec sp_spaceused 'TableName'
-- Check the
size of index
exec sp_spaceused 'Employees'
Thanks:)
Join the conversation! Your thoughts help the community grow.