One of the improvements for version 18.3 was a much improved, performant query builder. Of course, not all things are free. Or in fact, nothing is free. So who paid for these performance gains? We disabled one of its primary features. But first, let’s take a step a back and explain the scenario. How it Was, Pre 18.3 The query …
Query Builder: On Inline Views and ANSI Joins
Stumbling around on StackOverflow this morning, I came across this person’s HOMEWORK question, and the answer chided them on not using ANSI style JOINs. I’m not going to post the actual SQL here, but if you follow the previous link, it’s there for you to grab and have a go. Something I like to do is take REAL code off …
Force a Different Path with Automatic Plan Hints
Are you smarter than the optimizer? Are you hiding critical information from it? Perhaps your stats are missing, stale, or a bit misleading? I don’t want to get into whether hints are good or bad – they can only be used to accomplish good or bad things. They are often absused – so please don’t take this post as carte …
Oracle SQL Developer: Query Builder Video Demonstration
I’ve talked about the query builder a bit here on these pages, but sometimes a quick video can do a much better job demonstrating these concepts. The video is about 8 minutes and covers: writing a query the old-fashioned way writing a query with drag-and-drop from the tree using the Query Builder At about 5 minutes in, I talk about …