Thank you for your response.

I have run the DBCC commands and run the query.

Now the query returns the result very fast 🙂

I will run the query tomorrow again without running...

Hi, I have provided two queries in my first post

one is

select * from containstable(tbl_name, fieldname,'1607')

and another one is

select * from containstable(tbl_name, fieldname,'(isabout("1607 *")) or (isabout ("1607*") )')

First one is...

Thank you for your response.

But I wonder why this is very fast even first time in sql 2008?

select * from containstable(tbl_name, fieldname,'(isabout("1607 *")) or (isabout ("1607*") )')