Re: formula help please
Date: Sat, 05 Jan 2008 16:59:10 -0800
> 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.orgReceived on Sat Jan 05 2008 - 18:59:10 CST