Tags » Partitioning

Partitioned views over table partitioning

Today, we’re going to be looking at a kind of poor-mans’s-partitioning, using a view to union records from multiple tables. We’ll also take a look at when you would want this type of solution, some benefits and drawbacks, as well as ways to make things go faster. 1,690 more words

T-SQL

Partition Pruning - a case study .

Partition pruning if achieved can provide very good performance enhancement for sql query .
However sometimes we may think that the pruning happens automatically and will be taken care by Oracle optimizer . 636 more words

General

Integrating jOOQ with PostgreSQL: Partitioning

Introduction

jOOQ is a great framework when you want to work with SQL in Java without having too much ORM in your way. At the same time, it can be integrated into many environments as it is offering you support for many database-specific features. 1,395 more words

Sql

Reloading fact tables with zero downtime

If you’re working with data warehousing or reporting, you’ll recognize this problem as a recurring headache whenever you’re designing an ETL process for fact tables: If you want to completely reload all the rows of a fact table, you would typically start by emptying (or truncating) the fact table, and then load new data into it. 1,058 more words

T-SQL

What’s The Distinction Amongst GPT And MBR When Partitioning A Drive?

Set up a new disk on Windows 8.1 or 8 and you’ll be asked whether you want to use MBR or GPT. GPT is the new standard and is gradually replacing MBR. 12 more words

What’s The Variation Between GPT And MBR When Partitioning A Drive?

Set up a new disk on Windows 8.1 or 8 and you’ll be asked whether you want to use MBR or GPT. GPT is the new standard and is gradually replacing MBR. 12 more words

Shrinking windows partition
Creating GParted LiveUsb
Adding unallocated partition to Linux extended partition
Moving root partition to the left most
Resizing root
Moving home partition to the left most… 12 more words

Stories