Selecting into a view with no where clause is much faster that adding a where clause
Pulling my hair out with this. The following query returns in 9 seconds if the where clause is omitted, but takes minutes with a where clause. A select all into a temp table and issuing the where clause on the temp table takes ~22secs. SELECT Style AS Item ,Color ,[Size] ,QtyAvailable ,UPC ,Status ,DateAvailable AS EstimatedAvailDate FROM [LAN_VW_B2B_Upcs] WHERE ItemGroup = 'FG' AND ProductSegment IN ('BASIC', 'CORE', 'POS') AND Brand NOT IN ('IL')