Blog: Connor McDonald

211 blogs updated: 56 min. ago
Add ORDER BY to make ANY query faster
Yes it's SCBT day here in Perth! SCBT = Silly Click Bait Title This post is just a cautionary tale that it is easy to get caught up judging ...
07-11-2018 08:54:44 Connor McDonald Oracle
Interval versus Range partitions
One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to read large amou...
06-11-2018 03:06:35 Connor McDonald Oracle
The Openworld Mega-Download!
If you are sad and pathetic enthusiastic and interested in content like me, once a large conference like OpenWorld is over, I like to have t...
02-11-2018 03:49:41 Connor McDonald Oracle
The strange place for INHERIT PRIVILEGES
A while back in an Office Hours session, I touched on a relatively new privilege in the database called INHERIT PRIVILEGES which is designed...
31-10-2018 04:42:57 Connor McDonald Oracle
OpenWorld is done!
The OpenWorld conference is over for another year. It's always a thrill, albeit a hard-working thrill, to visit San Francisco and be a part ...
29-10-2018 04:11:26 Connor McDonald Oracle
18c XE–running locally
There's already a few blog posts out there, showing people (easily) getting their 18c XE instance downloaded, installed and running, so I wo...
21-10-2018 17:39:54 Connor McDonald Oracle
18c XE is live!
Just a quick post because this is perhaps what I think is one of the biggest game changers for the Oracle Database. 18c Express Edition (18x...
20-10-2018 20:03:54 Connor McDonald Oracle
OpenWorld Wednesday – step right up!
If you've read my two previous posts on the OpenWorld schedule, you're probably expecting a huge long list of sessions to pique your interes...
19-10-2018 03:31:50 Connor McDonald Oracle
Compressed LOB–my table got bigger?
We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying compression to ...
17-10-2018 09:31:13 Connor McDonald Oracle
LOBs vs Data – when compression occurs
Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is a dictionary attribute of the tabl...
16-10-2018 10:41:06 Connor McDonald Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.