As discussed previously, one of the nice features of an IOT Secondary Index is that it contains the mandatory Primary Key of the IOT, which is always maintained and can be used to access the necessary rows of the IOT regardless of row movement within the IOT itself. This can also be beneficial if only the PK [...]
I'll be doing four public events in the next week and a half or so.
The first one is open to anyone - anywhere. I'll be doing a live webinar on MAA - the Maximum Availability Architecture. It will take place this Thursday April 12th at 10am PDT. You should register online before then if you are interested.
After that, I'll be off to Belfast Ireland to do a repeat of what I presented at Oracle OpenWorld in October. This will be done in conjunction with Oracle and the UKOUG. See http://www.ukoug.org/events/tom-kyte-seminar-and-asktom-live/ for details, it'll take place on Monday April 16th.
Oracle 11g added Extended Statistics support for column groups in order to detect correlated columns for filter predicates using an equal comparison.
Note that Oracle 11g also added the ability to use the number of distinct keys of a composite index as an upper limit for the cardinality estimates for matching column predicates, which means that the optimizer is now capable of detecting correlated columns without the explicit addition of Extended Statistics / Column Groups.
Jack is reunited with his sister, just as a new virus threatens to link all human brains into a single collective hive mind, turning the human race into a docile petri dish living for the greater good of the virus.
Perhaps it’s my mood, but this story is just a little too depressing for my tastes. I’m hoping the rest of the series won’t degenerate into this type of doom and gloom. It needs a little more wit and humor to lift it.
Here is a poll prompted by today twitter talks on the default METHOD_OPT value (which is ‘for all columns size auto’ since 10g) and automatic statistics gathering job (auto-task since 11g). CBO development team suggests to use the default job to gather statistics with default options. Do you use the job exactly this way with real production databases? I’m very interested to see some numbers. Please share the poll link http://poll.fm/3n7pn so that more people vote. Thanks.
Just got this message today…
You can now earn twice as much free space by inviting your friends!
For each friend that installs Dropbox, you’ll both get 500 MB of free space. You can earn up to 16 GB.
Thanks for spreading the Dropbox love,
- The Dropbox Team
P.S. Already invited a bunch of people? Don’t worry! You’ll get credited for all of them.
Do you think Dropbox are getting nervous about Google’s GDrive?
Yesterdays move of the website went pretty smoothly from a technical perspective. I had done a trial run using a different domain name so I didn’t foresee any problems on that front. During the trial, the DNS propagation took less than an hour, but the real run took a little longer. Typical.
Let’s hope this marks the end of me harping on about hosting companies and website outages…