Re: Table Design

Oracle is pretty good at joining tables, that's its job.

Is a single table faster than joining 3? Yes.

Is the difference enough to matter? Probably not.

Design for the data, denormalize only if you can prove it's necessary. You and the developers will pay for it later if you don't.

Jared

On Tuesday 29 October 2002 22:53, Omar Khalid wrote:
> hi deepa
>
> i think Option-2 is a better choice if you want to go for retrieval speed.
> but this depends on the types of query you will perform on
> that table. generally joins are too costly speed wise so option-1
> one seems less efficient i mean more the table joins in u'r query the
> slower will be the retrieval of data.
>
> regards
>
> '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
> Omar Khalid
> Software Engineer
> LMK Resources
> Voice: 111-101-101*780
> Mobile: 0333-510-4465
> Web: www.lmkr.com
> '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
>
>
>
>
>
>
>
>
>
>
>
>
>
> PK_Deepa/VGIL_at_vguard.sat
> yam.net.in To: Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent by:
> cc:
> root_at_fatcity.com Subject: Table
> Design
>
>
> 10/30/2002 11:28 AM
> Please respond to
> ORACLE-L
>
>
>
>
>
> Hello
>
> We are doing database design for a project.
> We have 10 distinct transactions types and the total number of records is
> expected to be around 5,00,000
> taking all transactions together.We have normalised the tables and decided
> to store all of them together in a
> single table identified by the transaction type and other unique fields.
>
> We would like to know which option would be the best so that we can
> retrieve data most efficiently
> Option-1.
> Maintain 10 different tables for each transaction type (i.e 500000
> records will be split among 10 tables)
> Option-2
> Store all of them together in a single table identified by the
> transaction type and other unique fields.
>
> Regards,
> Deepa
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: PK_Deepa/VGIL_at_vguard.satyam.net.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).