SQL Stmt fine tune

[newvisva]

I have a SQL stmt that someone wrote... I'm trying to make it faster... anybody can share the idea?


SELECT *
FROM (SELECT ROW_NUMBER() OVER (ORDER BY DateModified DESC)
AS Row, * FROM activities where Location LIKE '%abcd%' or
Subject LIKE '%abcd%' or Location LIKE '%abcd%' or Availability LIKE '%abcd%' or RecurrenceXMLDetail LIKE '%abcd%' or ColorCode LIKE '%abcd%') AS ActRows
WHERE Row >= 1 AND Row <= 10

thanks