Listing 1: Query That Performs Differently on Similar Databases
SELECT ID, OrgName, Address1, Address2, Address3, Address4, AddressID,
   County, Postcode, Posttown, Privateaddress, NationalRecord, Level =0
FROM vSearchOrg
WHERE recordstatus = 'Complete'
AND (Keywordcode LIKE 'SK102810%' OR (OrgName LIKE '%SPOTS%'
   OR Service LIKE '%SPOTS%' ))
ORDER BY Orgname