tag:blogger.com,1999:blog-2623142444466153820.post5020309787103143591..comments2012-09-19T21:02:21.818-07:00Comments on My Blogs: Case Statements in SQLgaurav gaglanihttp://www.blogger.com/profile/16388697855572911151noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2623142444466153820.post-44122038087289524222012-09-19T21:02:21.818-07:002012-09-19T21:02:21.818-07:00@Mohsin Khan - I agree with as far as my knowledge...@Mohsin Khan - I agree with as far as my knowledge goes but I still think it depends on context of your query in "LIKE" you are doing some kind of wild card matching etc, In the "IN" type queries as parameters one usually has integers so the query will be fastergaurav gaglanihttps://www.blogger.com/profile/16388697855572911151noreply@blogger.comtag:blogger.com,1999:blog-2623142444466153820.post-49030349663071503722012-09-19T14:39:50.584-07:002012-09-19T14:39:50.584-07:00Also Guarav if you go with a Contains or IN wont t...Also Guarav if you go with a Contains or IN wont that help in performance optimization of record reading instead of like statements????Mohsin Khanhttps://www.blogger.com/profile/05264815611181096666noreply@blogger.comtag:blogger.com,1999:blog-2623142444466153820.post-69875992721656088102012-09-19T08:39:07.642-07:002012-09-19T08:39:07.642-07:00Thanks @Ratnadeep for the kind words.
About db vi...Thanks @Ratnadeep for the kind words.<br /><br />About db views I will surely try to put something out there that would be useful. gaurav gaglanihttps://www.blogger.com/profile/16388697855572911151noreply@blogger.comtag:blogger.com,1999:blog-2623142444466153820.post-2377733827288348602012-09-18T22:27:04.129-07:002012-09-18T22:27:04.129-07:00Awesome !
very informative.
Having a good ORM in ...Awesome !<br />very informative.<br /><br />Having a good ORM in between rails developer and db, makes these db skills bit unattended.<br /><br />Few days back I got to know of db views from one of discussions, would like to read one of your informative post on db views.curiosityhttps://www.blogger.com/profile/04368911791488861239noreply@blogger.com