I ran the following queries in ssms,the first query getting a result in a Sec after i changed a where clause data in a same query but it ran long time and getting timeout error. why this query behave like this.
2.Select * From BI_SERVICE_HEADER where BSH_pat_NUM ='IP/121203/00007'
This Query in 1 Sec
1.Select * From BI_SERVICE_HEADER where BSH_pat_NUM ='IP/121203/00008'