Rittman Mead - Delivered Intelligence

Our sales people have asked us to look at migrating a small (less than 3TB) DW system from another vendor’s database to Oracle. The DW database migration is conceptually not too difficult – we keep the user layer logically the same as now so they do not have to make major changes to their reporting [...]

One of our users raised a support call with my team – a query returned the wrong results. My guys check it out and capture the explain plan… yes wrong results, and because the lower bound of a BETWEEN prediacte was being omitted. So a TAR is raised with support – the captured plan is [...]

If you read my article a couple of weeks ago about the SQL Model clause you’ll probably be interested in a follow-up email I received yesterday from John Haydu, Product Manager within Oracle with responsibility for the Model clause. John clarifies a couple of points in the article which were a bit vague at the [...]

A few weeks ago (OK, in June; time flys when you are old!) I posted a piece of time series aggregation One technique I did not mention (and nobody reminded me of it ;-) ) was “partition joins”. This was a new feature introduced in Oracle 10g. Perhaps, the main reason I did not mention [...]