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 …