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. [EMAIL PROTECTED] -----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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
