Performance of multiple separate tables better than that of multiple partitions?

[Thorsten Mueller]

Hi,

I have a general question regarding performance: Are partitioned Tables equal to the same number of independent tables regarding performance?

Maybe I can explain my problem by an example:

I have a created a table "Hits" with more than 50.000.000 lines refering to 5 different "categories". (Referencing uses a secondary key=int in both cases).

There are two possibilities:

Partitioning the large "Hits" table in say 5 partitions by using KEY partitioning on a secondary key in the Hits table.

The other possibility would be to create 5 different "Hits" tables for each kategory ("HitsA", "HitsB", ...).

The usecases I am thinking of are thousands of INSERTS into the "Hits" tables or a multitute of Select queries like "SELECT h.* from Hits h, Kategory k where k.id = xy AND h.kategory_id = k.id "


It would be great if anybody could help me with this problem.

Thanks,

Thorsten