Re: Table Design Question pls help..

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 4 Oct 2004 15:37:21 GMT
Message-ID: <slrncm2r04.1dc.rene.nyffenegger@zhnt60m34.netarchitects.com>

In article <e1c9bd55.0410030537.3dc04dd1_at_posting.google.com>, 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 ?

I'd go for varchar2, myself, but HJR has already discussed it.  

> (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
> ?

Use one table. Then create two views that can be accessed for the reports with the according privileges. If it turns out to be too slow, create materialized views.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Mon Oct 04 2004 - 10:37:21 CDT