please look for my first post,i have included the schema as well as execution plan by editing it.

I am getting this warning message as well in select.

Type conversion in expression (CONVERT_IMPLICIT(uniqueidentifier,[ca].[CAId],0)) may affect "CardinalityEstimate" in query plan choice.

Please help me where i need to create data conversion...

yes i will list all the competency in one table as mentionedbefore but how do we select the partner for multiple conditions met.

I mean i need to select a partner...

Gold and Silver - is this related to Partner? Or to the Service being provided?

Its related to partner which they own it after meeting some sales criteria.

Direct and EA -...

Apology,pls consider this and suggest me.

I need some design help here.

This is my source input data which i need to select based on condition which is given by business.

create table...

Let me elaborate want i want to do.

I have a table

create table mastercompetency

(program varchar(10),

SKUgroup varchar(10),

competencyname varchar(10))

insert into mastercompetency values('DIRECT','SKG1','GOLD 1')

insert into mastercompetency values('DIRECT','SKG1','GOLD 2')

insert into mastercompetency values('EA','SKG2','GOLD 1')

insert into mastercompetency...

No But in My Query I am truncating it before i insert into ExceptMissingOLSMachine from ExceptionsTrackingTable by disabling the index and rebuild it later.

I have forgotten to...

It really didn't helped me out, seems something is wrong here does it due to 125 rows ??

Thanks for your suggestions.

One more help on the same line but here i don't have any SARGble function here its direct select and insert. As i am doing a join...

Hi Lange,

It Really helps me, I just changed the where clause as mentioned in your suggestion the query reduced to 1 minute from morethan 20 minute, you are awesome .!!

How...

PLAN ATTACHED.

sp_helpindex 'DML.ExceptionstrackingTable'

IX_DMLIsDeletedFlagganganonclustered located on PRIMARYDMLIsDeletedFlag

IX_gangaddednonclustered located on PRIMARYDMLIsDeletedFlag, OriginalSubscriptionKey

NCIX_ActivationModelnonclustered located on PRIMARYActivationModel, ExceptionType

NCIX_BatchIDnonclustered located on PRIMARYBatchID

NCIX_EntitlementIDnonclustered located on PRIMARYEntitlementID

NCIX_ExceptionsTrackingTable_CalcProductKeyIDnonclustered located on PRIMARYCalcProductKeyID

NCIX_GrpIDChannelIDSeqNononclustered located on PRIMARYGrpID, ChannelID, SeqNo

NCIX_IsDeletedFlagnonclustered located...

Hi Can you pls help me to study and understand the execution plan properly, i have not done this work earlier but not sure where to look,what to look so...

i dodn't have any table with name as ExtOLSMachine

CREATE FUNCTION [DML].[GetRetailOrOnlineIndicator](

@GrpID INT

,@ChanID INT

,@SeqNo INT

)

RETURNS NVARCHAR(10)

AS

BEGIN

DECLARE @RetailOrOnlineIndicator NVARCHAR(10)

IF EXISTS (SELECT 1...

1 st tabel is having 48 Lacks recoprds

the 5 th table is having 84 million records