November 2012

I’m feeling tired and incredibly aggressive today. It’s just been one of those days.

• I slept even worse than usual last night.
• I got to the gym and I’d forgotten my trainers.
• My Mo is pissing me off. If I didn’t have sponsorship it would be gone now!
• My Tuesday talk has been cancelled because the room wasn’t available.

Rather than stab some people in the face, I’ve taken a half-day off work and I’m going to read in the bath for a few hours, then go to bed and try and forget today ever existed.

Cheers

Tim…

Update: Now my microwave has just produced a mini lightning storm and died. What a day!

This is just a friendly reminder that I'll be talking at this year's DOAG Oracle conference about "Cost-Based Optimizer Basics" on Thursday, the 22nd of November, "Raum 1" at 13:00.

Additionally, I've reserved a slot at the "Unconference" (15:00 the same day) where I plan to present some of the interesting stuff that I cover as part of my "Parallel Execution Masterclass".

And soon the technical content will be back at this blog where I have lots of interesting stuff in the pipeline, mainly covering Parallel Execution topics.

Thank you all those who came to my sessions at PHLOUG in November. You can download the presentations and the demo scripts I used here.

Recently, I was creating an IOT from an existing table via, and wanted to achieve it without logging.

You cannot do this in two steps (ie, create table, followed by insert-append) because it will still be logged (see the addenda at the end of this post)

So you need to do it with a CTAS, for example:

create table MY_IOT
(…)
tablespace MY_DATA
organization index
nologging
as select * from ANOTHER_IOT order by ANOTHER_COL;

In my case, I opted for the “order by ANOTHER_COL” because this yielded an execution plan of INDEX FULL SCAN (not FFS) on ANOTHER_IOT, with no sort operation.  This sounded like a good thing to do, because this table was around a terabyte in size and I’d rather not be sorting that