Per my knowledge, SQL2 query optimization follows more or less similar best practices as SQL. You may search for 'SQL tuning best practices' and implement the same.This query is already using "CONTAINS" and specific node (nt:unstructured) to be searched which is good.Couple of things may be revisite...