Tags » Partitioning

Partitioning Solutions

Partitioning Solutions – an innovative and cost-effective way to protect your cabinets and equipment, easily adjustable and easy to install it is the perfect partitioning / room divider solution to suit an extensive range of applications. 64 more words

Shifting to Hive Part II: Best Practices and Optimizations

This is part two of an extended article. See part one here.

A full listing of Hive best practices and optimization would fill a book. All we’ll do here is skim over the topics that best indicate the spirit of Hive, and how it is used most successfully. 9,569 more words


ORA-14098 - Part 2: Primary Key vs. Unique Index

A couple of days ago I wrote about ORA-14098 during an “exchange partition” operation. The workaround was to simply disable the primary key constraint on both tables. 603 more words


Don't forget to pin us...

Partition Change Tracking with Surprise

Partition Change Tracking (PCT) is a powerful feature in Oracle for fast refresh of materialized views when one of the base tables is partitioned. But under certain conditions, PCT does not work as expected and returns an unpleasant surprise. 1,398 more words



I made a mistake a few days ago following up a question on the OTN database forum. The question was about a problem creating a hash/list composite partitioned table, and one of the respondants suggested that perhaps the problem appeared because hash/list wasn’t a legal combination. 401 more words


Managing VLDBs (Very Large Databases) and Tables

Databases having tables of tens of millions records need special considerations for data manipulations and maintenance operations. We’ll discuss few of the features in SQL Server that can help in this regard. 346 more words