Re: Design question : Normalize or Not to normalize ?

"xtanto" <krislioe_at_gmail.com> ha scritto nel messaggio news:e1c9bd55.0410130133.76fb0378_at_posting.google.com...
> Hi gurus,
>
> In our custom HR application, the employee master table has about 3,8
> million rows. Many transactions table has FK referring to the Big
> master table.
> (attached is the script sample)
> Question :
> Since the master table is big enough, should I still normalize here ?
> Means I have to JOIN to employee table to get the ENAME with the risk
> of slow join to big reference table ??
> Or this is the case where we should sacrifice normalization for
> performance?

well, PK and FK must be use to garaty referenced integrity. Es. when u delete or update one PK or FK u must be sure that reletaion will be respected.

For performance is sufficient to use correct index and OFA (when possible, whith partitioned tables) for relation table.

>
> Thank you for your help,
> xtanto
>
>
> CREATE TABLE EMP
> ( EMPNO NUMBER(4) NOT NULL PRIMARY KEY,
> ENAME VARCHAR2(30),
> bla..bla.. another 50 columns );
>
> CREATE TABLE PROMOTION
> ( PROMOTION_ID NUMBER(6) NOT NULL PRIMARY KEY,
> EMPNO NUMBER(4) NOT NULL ,
> ENAME VARCHAR2(30), bla..bla..bla );
> ALTER TABLE PROMOTION ADD (
> CONSTRAINT FK_EMPNO FOREIGN KEY (EMPNO) REFERENCES EMP (EMPNO));
Received on Wed Oct 13 2004 - 06:05:38 CDT