Re: Database Design for huge set of data
Posted by: Sunil H
Date: March 17, 2009 08:03AM

Yes it is 6.8e9 rows.
This is for reporting purpose.
table has 4 columns - id1(bigint),id2(bigint),time (time), value (double).
id1 is primary key, id2 is indexed.
It is a daily based table (2e7 rows) [ eg:table_2009_03_17 .. ]

Options: ReplyQuote


Subject
Written By
Posted
Re: Database Design for huge set of data
March 17, 2009 08:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.