partitionning join table and normalization

From: <>
Date: Tue, 8 Apr 2008 00:52:32 -0700 (PDT)
Message-ID: <>


I'm working on a database which contains a big table TD (10 millions lines) with many columns (180)

I wonder if the performance won t be better if i normalize some columns (about 20).

So this is the new table NORM_FIELD :
ID_DATA (ID reference from original table) FIELD_ID
+ 3 - 4 fields about updating (date, user, ...)

TD is partitionning case 2 columns.
Is it possible to partitionning NORM_FIELD which the same critery of TD ?
Even ifnot, what the better solution between :
- copy data of partitioning field in NORM_FIELD to store in the same
partition (and have this critery for the join condition)
- create a new partitioning critery for NORM_FIELD (like the last
digit for having the best distribution)

I don t want to change the application code, so i will rename my table and create a view with this name which will be a join with a another view build from this method :

Will performance be ok if i do this change ? What s about your experience ?

Thanks for answers.


PS : it is possible i've not be clear cause my poor english, in this case ask me to explain. Received on Tue Apr 08 2008 - 02:52:32 CDT

Original text of this message