hi all,
I want to know some information about table partitioning.
consider following script
create table `customers`(
`CustomerID` varchar(40) not null,
`TimeCreated` DATETIME not null default 0,
`TimeModified` datetime not null default 0,
`isActive` tinyint not null
ng
it.
The first problem that you will see is the PK and unique keys in
partitioning have to have the partition key as part of the index. So your
PK would have to be CustomerID, TimeCreated
-Original Message-
From: gunwant walbe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007
#x27;1995-12-31';
++-+
| CustomerID | TimeCreated |
++-+
| 4 | 1992-11-28 08:13:09 |
| 5 | 1987-11-28 08:13:09 |
++-+
-Original Message-
From: gunwant walbe [mailto:[EMAIL PROTECTED]
Sent
