warning about conversion on sys.sysschobjs in the execution plan

I noticed a warning in my query plan and it came out to be these two (related to sys.sysschobjs):

    Type conversion in expression   (CONVERT(char(2),[mydatabase].[sys].[sysschobjs].[type],0)<'U')   may affect "SeekPlan" in query plan choice,   Type conversion in expression   (CONVERT(char(2),[mydatabase].[sys].[sysschobjs].[type],0)<'S')   may affect "SeekPlan" in query plan choice 

I would like to know exactly what is causing this warning.

my table in question is this one:

IF OBJECT_ID('[dbo].[ProductItemDetailsDenorm]') IS NOT NULL  DROP TABLE [dbo].[ProductItemDetailsDenorm]  GO CREATE TABLE [dbo].[ProductItemDetailsDenorm] (  [ProductURLID]               INT                              NOT NULL, [ClassID]                    INT                              NOT NULL, [SegmentID]                  INT                              NOT NULL, [GroupID]                    INT                              NOT NULL, [ItemNo]                     VARCHAR(10)                      NOT NULL, [Tier1]                      VARCHAR(10)                      NOT NULL, [Tier2]                      VARCHAR(10)                      NOT NULL, [Tier3]                      VARCHAR(10)                      NOT NULL, [LanguageID]                 SMALLINT                         NOT NULL, [GenderCode]                 CHAR(1)                          NOT NULL, [URL]                        NVARCHAR(250)                    NOT NULL, [SeasonItemID]               VARCHAR(5)                       NOT NULL, [SeasonID]                   CHAR(1)                          NOT NULL, [Tier1Descr]                 NVARCHAR(250)                    NOT NULL, [Tier2Descr]                 NVARCHAR(250)                    NOT NULL, [Tier3Descr]                 NVARCHAR(250)                    NOT NULL, [Tier2Sort]                  INT                              NOT NULL, [Tier3Sort]                  INT                              NOT NULL, [WasPrice]                   DECIMAL(18,4)                    NOT NULL, [Price]                      DECIMAL(18,4)                    NOT NULL, [PricePreTax]                DECIMAL(18,4)                    NOT NULL, [PriceTaxRateApplied]        DECIMAL(18,4)                    NOT NULL, [SaleDiscount]               DECIMAL(18,4)                    NOT NULL, [FullDescription]            VARCHAR(10)                      NOT NULL, [ZoomImageData]              NVARCHAR(10)                     NOT NULL, [ProductWarning]             NVARCHAR(250)                    NOT NULL, [AdditionalDetailsText]      NVARCHAR(max)                     NOT NULL, [AdditionalMeasurementText]  NVARCHAR(max)                     NOT NULL, [HemmingT1]                  VARCHAR(10)                      NOT NULL, [SortOrder]                  SMALLINT                             NULL, [ParentGroupID]              INT                              NOT NULL, CONSTRAINT   [PK_ProductItemDetailsDenorm]   PRIMARY KEY CLUSTERED    ([ClassID] asc,                            [SegmentID] asc,                            [GroupID] asc,                            [ParentGroupID] asc,                            [ProductURLID] asc))  GO 

and here is my query:

declare      @StyleCode varchar(10),     @ClassId int,     @SegmentId int,     @GroupId int,     @LanguageId smallint  select    @StyleCode ='MB149',    @GroupID = 362,    @ClassId = 1,    @SegmentId = 1,    @LanguageId =2                 select                 t2.Tier1 as [StyleCode],                 t2.Tier1Descr as [StyleDescription],                 coalesce(t1.URL, t2.URL) as [StyleUrl],                 t2.Tier2 as [ColourCode],                 t2.Tier2Descr as [ColourDescription],                 t2.URL as [ColourUrl],                 t2.ClassID,                 t2.SegmentID,                 t2.GroupID,                 t2.SeasonItemID                 from dbo.ProductItemDetailsDenorm t2                      INNER JOIN dbo.ProductItemDetailsDenorm t1                                   on t2.Tier1      = t1.Tier1                                 and t2.ClassID    = t1.ClassID                                  and t2.SegmentID  = t1.SegmentID                                  and t2.GroupID    = t1.GroupID                                  and t2.LanguageID = t1.LanguageID                                 and t1.Tier2 = ''                      where   t2.Tier1      = @StyleCode                         and t2.ClassID    = @ClassId                         and t2.SegmentID  = @SegmentId                         and t2.GroupID    = @GroupId                         and t2.LanguageID = @LanguageId                         and t2.Tier2      <> ''                         and t2.Tier3      = '' 

Replay

Category: sql server Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 3.101 (s). 13 q(s)