Correct Concept On Table Partition

Currently, I plan to use table partition to solve the following problem.

I have a table which is going to grow to a very huge row, as time goes on.

As I know, as table grow larger, the read operation will be slower.

Hence, I decide to use table partition, in order to improve read speed.

I have parent table named measurement.

Then I will have child tables named measurement_1, measurement_2, ....

First 1st millions rows will be write to measurement_1, 2nd millions into measurement_2, ....

My understanding is,

(1) measurement table will act as a virtual table, which make me easy for me to perform query read and query write.

(2) measurement_1, measurement_2 will be "real" table.

(3) when viewing the 2nd millions row (1,000,001 - 2,000,000) of measurement,

before partition
================
instead of reading total 2 millions row, and displaying the (1,000,001 - 2,000,000)

after partition
===============
we will just need to access table measurement_2 only, which is smaller, and shall be faster.

(4) extensive join operation will be involve. I am more concern into read speed.


Is this the correct expectation, on table partition?

Thanks and Regards
Yan Cheng CHEOK