USP_MKTSELECTION_EXISTS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@FORCELEGACYCARDINALITYESTIMATOR	bit	IN
@MKTSELECTIONEXIST	bit	INOUT

Definition

Copy



create procedure dbo.[USP_MKTSELECTION_EXISTS]
(
  @ID uniqueidentifier,
  @FORCELEGACYCARDINALITYESTIMATOR as bit,
  @MKTSELECTIONEXIST bit output

)

as begin

If @FORCELEGACYCARDINALITYESTIMATOR = 1
  select @MKTSELECTIONEXIST = (select top 1 1
            from dbo.[IDSETREGISTER]
            left join dbo.[IDSETREGISTERADHOCQUERY] on [IDSETREGISTERADHOCQUERY].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
            left join dbo.[IDSETREGISTERSMARTQUERYINSTANCE] on [IDSETREGISTERSMARTQUERYINSTANCE].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
            where [IDSETREGISTERADHOCQUERY].[ADHOCQUERYID] = @ID
            or [IDSETREGISTERSMARTQUERYINSTANCE].[SMARTQUERYINSTANCEID] = @ID
            or [IDSETREGISTER].[ID] = @ID )
            OPTION (USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION'));
else
  select @MKTSELECTIONEXIST = (select top 1 1
            from dbo.[IDSETREGISTER]
            left join dbo.[IDSETREGISTERADHOCQUERY] on [IDSETREGISTERADHOCQUERY].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
            left join dbo.[IDSETREGISTERSMARTQUERYINSTANCE] on [IDSETREGISTERSMARTQUERYINSTANCE].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
            where [IDSETREGISTERADHOCQUERY].[ADHOCQUERYID] = @ID
            or [IDSETREGISTERSMARTQUERYINSTANCE].[SMARTQUERYINSTANCEID] = @ID
            or [IDSETREGISTER].[ID] = @ID );
end