simply replace * with column name. It will reduce the time for executing the query.
cretae procedure [dbo].[getcount]
(
@keyword varchar(50),
)
as
declare
@totalCount int OUT
begin
select @totalCount=count(column1) + count(column2) + count(column3) from TableName where ((Column1 Like '%'+@keyword+'%') or(Column2Like '%'+@keyword+'%') or (Column3 Like '%'+@keyword+'%'))
end