You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID and a…

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID and a non-clustered index named AK_Product_ProductNumber. Both indexes have been created on a single primary partition. The table has the following definition:

You want to ensure that data retrieval takes the minimum amount of time when the queries executed against the Production. Product table are ordered by product number or filtered by class. You need to find out the degree of fragmentation for the indexes on the Production.Product table. Which Transact-SQL statement should you use?