Count Query In Ms sql

Count Query In Ms sql -Fast


select case when COUNT(*) =0 then 'add' else 'Remove' end from tbl_Deal_Category_Mapping where tblCategory.Category_ID=tblProduct.Category_ID)as status

On Product and category Join