Hi there,<BR><BR>I've got a little problem. I need to join two tables both have the field "Product_ID" but the contents of the columns differ slightly. For example:<BR><BR>Table 1<BR>Field: Product_ID ...
In earlier versions of SQL Server, after selecting a join algorithm, SQL Server had to process it even if a better alternative might be available. In SQL Server 2017, the query optimizer can now sense ...