Dear All
I have write a SP in which i use "code" field in query in where clause. This field was int. For the purpose of optimization according to the client now i want to change the Code field into CHAR(10) so i changed and after this change when i execute the SP it's take to much time as compare to before . Before change it was executed for the month in 15 months and after change it takes more than one hour for the month.
What can be issue with it, any body help me.
Thanks
Qaiser