Hi Jake,

thanks for ur reply.

i found the solution.

in my query @art_Filter use indexed search keywords so that here is the problem i found.

ex. i use contains(columnname,condition).....

hi jack,

this is my exact procedure.

CREATE procedure [dbo].[Search_and_paging]

@art_Filter varchar(8000),

@sect_Filter varchar(8000),

@PageNumber int=1,

@pageSize int=20 ...