Re: Partitioning a large table by month

From: Eagle Fan <eagle.f_at_gmail.com>
Date: Mon, 12 Nov 2007 09:15:11 -0000
Message-ID: <1194858911.984407.98590@e9g2000prf.googlegroups.com>

On Nov 12, 2:11 pm, mister...._at_gmail.com wrote:
> One thing I forgot, the table has several years stored, but I just
> want the 12-month partitions without caring for the years. Thanks again

You can add partition_key column which is based on month number. Received on Mon Nov 12 2007 - 03:15:11 CST