RE: Table Design

Deepa - What is the purpose of this table? This smells a little like a data warehouse type project, where the design rules get bent a little (some might say warped). Are your users going to be doing a lot of creative queries on this data to try to draw business conclusions?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, October 30, 2002 11:34 AM To: Multiple recipients of list ORACLE-L

Deepa ,
there are various considerations here , if your are using oracle and using proper indexes and proper query 5,00,000 records is not a big thing. I dont think you will see much difference . If your queries does full scan then may be your theory is rite
second consideration would be how the application request data . Is it randomaly from transaction type ?
Somehow I have a feeling that one table can do the job . Less maintainance and less parsing ( since u r using same table )

oramagic

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 29, 2002 10:28 PM

> 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: BigP
  INET: big_planet_2000_at_hotmail.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).