Re: formula help please

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 05 Jan 2008 16:59:10 -0800
Message-ID: <1199581123.284935@bubbleator.drizzle.com>


Totti wrote:
> Charles, the tables are huge > 2000 rows each. so as u pointed that
> must be a problem;
> the other problem is that as i am checking the .txt file , the data is
> generated from, i can see no costraints in the creating tables
> statments, and as i understood from you, the constraints and the
> primary and foreign keys are essentials in solving such problems.
> what do you suggest now? should i drop present tables and put
> constraints in re-generating the data? or could i work it out in
> another more sophisticated way?
>
> Thank you very much Charles you are being very helpful for me.

Just a short note ... 2000 rows is microscopic. Production tables in most Oracle databases are holding hundreds of thousands and millions of rows if they are not being used for lookup purposes.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jan 05 2008 - 18:59:10 CST

Original text of this message