Sunday, August 7th, 2005 by Peter Scott
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 […]
Wednesday, August 3rd, 2005 by Peter Scott
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 […]
Wednesday, August 3rd, 2005 by Mark Rittman
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 time.
"I’m the Oracle product manager […]
Monday, August 1st, 2005 by Peter Scott
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 it […]
