I am off for a much-needed vacation, so this blog is going on hiatus until mid-June. You’re welcome to post comments and questions; they’ll be reviewed and approved for publication in my absence. However, I won’t be publishing any new articles until my return. See you in a few weeks. Link to the original site
At some point, you have to climb back into the saddle. This blog is coming off hiatus; I’m back. We’re getting back to our regular publication cycle now. Your countless emails and posted comments have been a source of comfort and strength through this very-difficult time. They mean more to me than I can adequately [...]
This blog is going on hiatus for an undetermined period. My wife of 22 years has just announced that she’s leaving me. It’s going to be very hard for me to focus on work for a while, so rather than do you the disservice of incoherent articles and non-linear responses to your comments and questions, [...]
So, I’m back from my brief hiatus. Interestingly, traffic spiked on Friday the 4th when I posted that note. Not entirely sure why, but maybe some of you saw the post title in your readers and thought something noteworthy had happened. Sorry to disappoint. Part of the reason I took time off was to perform [...]
We apologize for our brief hiatus from blogging. We’ve been busy working on improvements to the optimizer. In 10gR2, we introduced a new transformation, table elimination (alternately called “join elimination”), which removes redundant tables from a query. A table is redundant if its columns are only referenced to in join predicates, and it is guaranteed [...]