3 ms·
> DB2 is just the same thing as Oracle. DB2 supports sub-capacity licensing on a wide variety of virtualisation platforms, unlike Oracle. This may or may not
by rodgerd 12y ago
> DB2 is just the same thing as Oracle.
DB2 supports sub-capacity licensing on a wide variety of virtualisation platforms, unlike Oracle. This may or may not matter to you. It does to me under a variety of circumstances.
DB2 also has much more granularity in licensing before you have to ramp up to ASE, which, again, may make a big difference to you (many equivalent features are available a significantly lower price points).
> So you'll use every proprietary Oracle feature that gives you additional performance (subpartitions, parallel query execution, optimizer hints, manual column statistics, connect by, listagg, …).
More than a few of these are trivial conversions to other DBs. CONNECT BY is hardly magic, neither's parallel query execution or listagg.
Operational concerns are probably the biggest one.
> Take all this together and we're pretty much locked into Oracle.
If you're in a business where running your company on whatever schedule Oracle chooses to offer you, that won't be a problem.