Queries for NOEXPAND Table Hint

1. Usage of Table index NOEXPAND (works only with indexed views)

SQL Server Query 1

            
 SELECT  

     CustomerID,  

     ProductID,  

     TotalProductSales  

 FROM dbo.CustomerProductSalesIndexed WITH (NOEXPAND)  

 WHERE TotalProductSales > 1000  

 ORDER BY TotalProductSales DESC;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns(" CustomerID","ProductID","TotalProductSales")  

     .From("dbo.CustomerProductSalesIndexed",  new List<IHint>() { new NOEXPAND()})  

     .Where(new Where(new Column("TotalProductSales").GreaterThan(1000)))  

     .OrderBy(new OrderBy().SetColumnDescending("TotalProductSales"))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT CustomerID,
       ProductID,
       TotalProductSales
FROM dbo.CustomerProductSalesIndexed WITH (NOEXPAND)
WHERE TotalProductSales > @pMAIN_2507192016471667190
ORDER BY TotalProductSales DESC;


            
        

Parameters (If used)

Query Results 1: