HResults.DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS Field
There are more than 16 exact match joins, so performance may not be optimal. Reduce the number of exact match joins to improve performance. SQL Server has a limit of 16 columns per index, the inverted index will be used for all lookups.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Const DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS As Integer
'Usage
Dim value As Integer
value = HResults.DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS
public const int DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS
public:
literal int DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS
static val mutable DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS: int
public const var DTS_W_FUZZYLOOKUP_TOOMANYEXACTMATCHCOLUMNS : int