深圳智汇创想科技有限公司

[性能问题描述]

(@CustomerID int,@SKU nvarchar(4000),@OrderSourceCountry varchar(4000),@Status bigint,@UploadType bigint) SELECT c.BrowsePathByID,                                          d.SKU                                   FROM   RB_AmazonUploadResult_V2 c (nolock)                                          INNER JOIN RB_AmazonUploadProduct_V2 d(nolock)                                            ON c.CustomerID = d.CustomerID                                               AND c.ID = d.QueueID                                          INNER JOIN RB_OrderSource b(nolock)                                            ON d.CustomerID = b.CustomerID                                               AND d.OrderSourceID = b.ID                                   WHERE  c.CustomerID = @CustomerID                                          AND d.SKU = @SKU                                          AND b.OrderSourceCountry = @OrderSourceCountry                                          AND d.Status = @Status                                          AND Isnull(d.UploadType, 1) = @UploadType                                          AND d.IsParent = 0                                          AND c.AddUserID>0                                          AND d.AddUserID>0                                   GROUP  BY c.BrowsePathByID,                                             d.SKU

[分析过程] 数据库d.SKU 的数据类型 为 varchar，传入的值为nvarchar

[期望结果] 请把传入的nvarchar 指定了 varchar 类型，以保证数据库使用正确的索引。