Please help in query optimization : Please help in query optimization. I have one table which contains some members and their card. There are 3 unique type of cards i.e. ADIB, ADCB & NBAD.
One person may have more than one card & also one person may have more than one type of card i.e 2 ADIB cards.

Below is my query, please optimise:

create table #cobrand(grp_number nvarchar(12), partner varchar(5))

insert into #cobrand
select distinct c_grp_number grp_number, 'NBAD' partner from partnership_cards c where partner_name = 'NBAD'
and not exists (select grp_number from #cobrand t where c.c_grp_number = t.grp_number)

insert into #cobrand
select distinct c_grp_number grp_number, 'ADIB' partner from partnership_cards c where partner_name = 'ADIB'
and not exists (select grp_number from #cobrand t where c.c_grp_number = t.grp_number)

insert into #cobrand
select distinct c_grp_number grp_number, 'ADCB' partner from partnership_cards c where partner_name = 'ADCB'
and not exists (select grp_number from #cobrand t where c.c_grp_number = t.grp_number)


Thanks in advance,
Nishant