Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table Design Question pls help..

Re: Table Design Question pls help..

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 03 Oct 2004 21:48:06 -0700
Message-ID: <1096865366.961092@yasure>


Comments in-line.

xtanto wrote:

> Hi gurus,
>
> I have two design question, could you please give some reccomendation
> :
>
> (1) Instead of CHAR, I plan to use VARCHAR2 for all character type
> column. This is to avoid having to use RTRIM for char comparison from
> within Forms application. Is there any bad impacts of this design
> decision ?

No.

> (2) We have two tables of organization membership, one for 'permanent'
> member , the other for 'non-permanent' member. After two years,
> non-permanent member will become permanent member. The permanent
> member is 4.000.000 rows and the non permanent member is about 200.000
> rows.
> These two tables are separated because there are reports that are only
> dedicated to Non-permanent member, so that the query will be faster.
> BUT there are also reports that combine the two tables using UNION.
> Is using UNION with this amount of rows will cause any bad performance
> ?
> Or these two table should be only one tables using member-type column
> ?
>
> Thank you for any comments,
> xtanto

Combine the tables. Your design is non-relational and guaranteed to create problems.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Oct 03 2004 - 23:48:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US