I am querying against a big table on a server. Is there a quicker way to run my logic. Below is the sample, I was thinking the way I am calculating the date is making it slow.
where 'MID' IN ([INS1_HL]
and left(partnum_hl, 3) like 'BMC'
and [DESCRIPTION001_HL] like '%Accu%'
and [INV_DT_HH] Between GetDate()-366 and GetDate()