anthony.green (12/12/2012)
yes I saw the execution plan, should upload them as SQLPLAN files as we can then open then in SSMS and naviagte the objects and see the stats, but as they are pretty simple, you can see that full text is the better plan
i always do and prefer but today i am using VDI so cant be able to thats y i took the screenshot 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)