Thanks to those of you who attended the Ask Tom Office Hours session on setting up the Oracle Optimizer for a Proof of Concept. Here's a PDF copy of the deck I used and it's available on slideshare too.
A video recording is available here.
Many applications need to paginate rows fetched from the
database, or at least retrieve the first N rows. In most cases
the data needs to be...
There are a number of ways to speed up the process of gathering
optimizer statistics, but I'm not sure that it's common knowledge
This feature made its debut in Oracle
Database 12c Release 2 and enhancements in Oracle Database
18c allow it to be used in a broader range...