Remove the 'N' from WHERE clause when not NVARCHAR
Tal Mickel shared this idea 1 year ago
YF treats string values as NVARCHAR when using in where clause. This can cause performance slow down.
Can we please only have Yellowfin include the 'N' when querying NVARCHAR columns?
Here is example of query being run against VARCHAR column.
Select DISTINCT "First Name", "Last Name" FROM "Users" WHERE "Region" IN (N'APAC', N'NA')