tag:blogger.com,1999:blog-5849265.post2220314201493977050..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: What does Avoid non SARGable where clause mean?Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5849265.post-59792650120143208492013-06-10T12:50:35.300+05:302013-06-10T12:50:35.300+05:30Hey there. That was a very good explaination. Than...Hey there. That was a very good explaination. Thanks for it. I had a doubt as i am a new beeie..<br />In the Example 3 shown, you suggested not to use wildcards on both the side like '%ab%' as it will perform whole table scan for searching (correct me if i am wrong). So what is the alternate for such a query!?Vidhi Shahnoreply@blogger.com