It seems to me that you should brush up on "normal forms" and the rationale
behind them.
(particularly the "suggestions" regarding dependencies between keys and
attributes)
"Marc" <Marc-Weinstock_at_si.rr.com> wrote in message
news:fe_49.195542$QD2.43806028_at_twister.nyc.rr.com...
> Which is faster? 6 columns or 1 column with all keys. Speed is the only
> issue.
> col1 varchar(3) = aaa
> col2 varchar(3) =bbb
> col3 date =12/31/01
> col4 number(1) =1
> col5 number(1) = 0
> col6 number(1) =1
>
> OR
>
> one_column varchar2(20) = "aaabbb12312001101"
>
> I have a few tables with the same primary key. For perfomce only. does
> anyone know? MultiMillion row table.
>
>
>
Received on Tue Aug 13 2002 - 16:20:26 CDT
