CREATE_OR_DROP_DIM_CONSTITUENT_STAGE_INDICES

create procedure [BBDW].[CREATE_OR_DROP_DIM_CONSTITUENT_STAGE_INDICES]
  @CREATE_OR_DROP bit --1 to create, 0 to drop.
  as
  set nocount on;

  if @CREATE_OR_DROP is null
  raiserror('@CREATE_OR_DROP must be 1 or 0 in [BBDW].[CREATE_OR_DROP_DIM_CONSTITUENT_STAGE_INDICES]',16,10);

  if @CREATE_OR_DROP = 1
  begin
  --create
    if  [BBDW].[UFN_INDEXEXISTS]('IX_DIM_CONSTITUENT_STAGE_CONSTITUENTADDRESSSYSTEMID') = 0
      create nonclustered index [IX_DIM_CONSTITUENT_STAGE_CONSTITUENTADDRESSSYSTEMID] on [BBDW].[DIM_CONSTITUENT_STAGE] ([CONSTITUENTSYSTEMID]) with (DATA_COMPRESSION = PAGE) on [BBRPT_STAGEGROUP]

  end
  else
  begin
  --drop

    if  [BBDW].[UFN_INDEXEXISTS]('IX_DIM_CONSTITUENT_STAGE_CONSTITUENTADDRESSSYSTEMID') = 1
     drop index [IX_DIM_CONSTITUENT_STAGE_CONSTITUENTADDRESSSYSTEMID] on [BBDW].[DIM_CONSTITUENT_STAGE];

  end