Created a table in such a way, each rowsize is one 8K page.

Now when I execute this

SELECT T.name as 'Table', ix.index_id, ix.[name] AS IndexName, ix.type_desc AS IndexType, [ips].[index_level], ips.page_count...