like use union all instead of union use a comparision operator like > or Use EXISTS keyword rather than IN There was a query where it is substring(firstname,1,3)='Cha' instead of firstname like 'Cha%' Use seperate conditions instead of concatenating two fields