Re: A first table partitioning exercise.

[patrick flaherty]

I wanted to post this before but the standard topic post form doesn't show that BBCode tags are supported.

Just read a sticky and they are supported.

So here's what I see:

mysql> select count(*) from part_tab where c3 > date '1995-01-01' and c3 < date
'1995-12-31';
+----------+
| count(*) |
+----------+
|   795181 |
+----------+
1 row in set (3.28 sec)

mysql>
mysql> select count(*) from no_part_tab where c3 > date '1995-01-01' and c3 < da
te '1995-12-31';
+----------+
| count(*) |
+----------+
|   795181 |
+----------+
1 row in set (5.09 sec)

... (preview) hmm, it's not a color-coded, offset block. Oh well.