Merge joins are not currently part of the heuristics. • Batch-mode memory grant feedback: Previously, SQL Server took a cardinality estimate for a given T-SQL batch and then estimated the minimum ...

I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.