Re: How to partition my table
Say, If I have a table named 'Employee' who has lots of data based on a unique Emp ID. Now if I partition it with alter table say P1 will hold ID from 1 to 1000, P2 1001 to 2000 and so on.
Currently the queries are like
<select something from `Employee` where condition>.
Now should the query be same or I have to rewrite it as
<select something from P1 where condition> and mysql will smartly find out that P1 holds the data I need for query.
Thanks.
Subject
Views
Written By
Posted
10082
March 15, 2009 09:36AM
4639
March 15, 2009 01:09PM
3915
March 17, 2009 10:35PM
3525
March 18, 2009 12:16AM
Re: How to partition my table
3363
March 18, 2009 09:12PM
3354
March 18, 2009 10:19PM
3677
March 19, 2009 05:18AM
3621
March 19, 2009 05:34AM
3337
April 06, 2009 08:08AM
3839
April 07, 2009 09:44PM
2679
April 08, 2009 08:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.