Re: How to partition my table

[Aftab Khan]

>Now if I partition it with alter table say P1 will hold ID from 1 to 1000, P2 1001 to 2000 and so on.

How many rows do you have in `Employee` table? if you have e.g. 10000000, in this case you need 10000 partitions.

lets do some tests

CREATE TABLE Employees (
EmpID INT NOT NULL,
....
)
PARTITION BY KEY()
PARTITIONS 4;

Load data into this table...

>Now should the query be same or I have to rewrite it as
yes your query will remain same

And then verify the partition used
EXPLAIN PARTITIONS SELECT * FROM Employees WHERE EmpID=1000;