Yesterday’s posting was a reminder that bitmap indexes, unlike B-tree indexes in Oracle, do store entries where every column in the index is null. The same is true for cluster indexes – which are implemented as basic B-tree indexes. Here’s a test case I wrote to demonstrate the point.
Yesterday’s posting was a reminder that bitmap indexes, unlike B-tree indexes in Oracle, do store entries where every column in the index is null. The same is true for cluster indexes – which are implemented as basic B-tree indexes. Here’s a test case I wrote to demonstrate the point.
In order to help me stick to my commitment to blog more regularly, I've joined the blogging community at Toad World. I'll link to most posts from there as I make them (I love knocking down two targets with one arrow) and keep on track for at least one post a week moving forward. Yea!
I know I keep calling it the “spring” conference, but in my mind the two BGOUG conferences are always spring and autumn. This year the “spring” conference was a little late, hence my apparently strange blog titles.
I was initially planning to get a taxi from Sandanski to Sofia airport. Fortunately Sve and Mimi were driving back at the same time, so I got a lift with them, which was much better company.
The flight from Sofia to Munich went as planned. After a 110 minute layover in Munich, it was time for the last leg of the journey to Birmingham. Once again, so drama there.
This is the index to a series of articles I’ve been writing for redgate, published on their AllThingsOracle site, about generating and reading execution plans. I’ve completed a few articles that haven’t yet been published, but I’ll add their URLs when they’re available.
I don’t really know how many parts it’s going to end up as – there’s an awful lot that that you could say about reading execution plans, even when you’re trying to cover just the basics; every time I’ve started writing an episode in the series it’s turned into two episodes. I’ve delivered 5 parts to redgate so far; the active URLs below are the ones that they are currently online.
It’s fairly well known that in Oracle B-tree indexes on heap tables don’t hold entries where all the indexed columns are all null, but that bitmap indexes will hold such entries and execution plans can for predicates like “column is null” can use bitmap indexes. Here’s a little test case to demonstrate the point (I ran this last on 12.1.0.1):
It’s fairly well known that in Oracle B-tree indexes on heap tables don’t hold entries where all the indexed columns are all null, but that bitmap indexes will hold such entries and execution plans can for predicates like “column is null” can use bitmap indexes. Here’s a little test case to demonstrate the point (I ran this last on 12.1.0.1):
I am a long time supporter of Samsung products- I’ve always had Samsung phones, (currently a Note 3 owner…) Samsung TVs, monitors and even have a Samsung microwave and refrigerator. I love Samsung products and this has included my tablets, recently deciding to upgrade my Samsung Note 10.1, (original) for a Samsung Note Pro 12.2.
The Day 1 evening festivities consisted of lots of food, followed by a group doing a display of traditional dances. Once they had finished it was up to me to teach the Bulgarians how their local dances should really be done. Needless to say I smashed it!
Day 2 started with a swim and breakfast. When I say swim, I really mean gentle floating, wishing I was still in bed.
The first session I went to was Joel Goodman‘s session on “RAC Global Resource Management”. Lot’s of good stuff! Joel is like a walking Oracle encyclopedia.
Until OEM11g, it was very common that all folks were either Super Administrators or Administrators and only a few shops took the time to create roles outside of these two essential roles. Super Administrator, (SA) was pretty straight forward- the SA had essentially the same access as the repository owner and should only be allocated to those that should have this deep access to the Enterprise Manager environment, but admi
Recent comments
3 years 6 weeks ago
3 years 18 weeks ago
3 years 22 weeks ago
3 years 23 weeks ago
3 years 28 weeks ago
3 years 49 weeks ago
4 years 17 weeks ago
4 years 47 weeks ago
5 years 31 weeks ago
5 years 31 weeks ago