The use of "LIKE" in a statement

[Crystalguru]

I am re-evaluating the performance of a query and noticed that the query contained several LIKE statements. Will this affect performance of the query?

AND ((cd.DocumentName = 'PDB_Patient Database'
AND (obs.DisplayName = 'PDB_LivingWill_O'
OR obs.DisplayName = 'pdb_DPOA'
OR obs.DisplayName = 'pdb_DPOAname'
OR obs.DisplayName = 'PDB_PatientUseAlcohol'
OR obs.DisplayName = 'pbd_NumberYearsDrank'
OR obs.DisplayName Like 'pdb_number%'
OR obs.DisplayName = 'pdb_typeofalcohol'
OR obs.DisplayName Like 'PDB_Tobacco%'
OR obs.DisplayName Like 'PDB_Drug%'
OR obs.DisplayName = 'PDB_Treatments'
OR obs.DisplayName Like 'PDB_Imm%'
OR obs.DisplayName = 'PDB_Fludate'
OR obs.DisplayName = 'PDB_Pneumoniadate'
OR obs.DisplayName = 'PDB_Tetanusdate'
OR obs.DisplayName = 'PDB_Otherimmundate')

 

[SQLDenis]

'PDB_Tobacco%' unlike '%PDB_Tobacco%' is Sargable and should be fine
The optimizer will translate that to

> 'PDB_Tobaccn_' and < 'PDB_Tobaccp'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/