News for hackers. Stuff that matters.
Re:Easy Steps to a Complete Understanding of SQL by lukaseder on Tuesday September 03, 2013 @10:33AM (#6321181)
That really depends on the database. With MySQL? Yes, you have to apply hundreds of tricks. With Oracle? Chances are, that the CBO knows much better than you how to transform your SQL.
Re:Easy Steps to a Complete Understanding of SQL by chris_wot on Tuesday September 03, 2013 @10:41AM (#6321235)
Tell that to all those people still adding rule hints to their queries :-)
Re:Easy Steps to a Complete Understanding of SQL by lukaseder on Tuesday September 03, 2013 @10:50AM (#6321276)
Good point. It's been some time though, since I've last been using anything below Oracle 12c ;-)