Re: millions of records
Posted by:
Kevin Hurst
Date: September 26, 2005 04:30PM
Thanks for the reply, Jay.
I have spent some time revamping the database choosing optimal data types instead of being so generic. New indexes on key fields have also been added. These changes have already seemed to greatly improve the time the queries take to run. There is just mostly a question on if having millions of rows in a single table is just bad database design or not, even though it seems it is unavoidable. Does having data fields with the potential of null dramatically decrease performance that much?
Subject
Views
Written By
Posted
5659
September 03, 2005 12:04PM
2498
September 05, 2005 12:24PM
Re: millions of records
2300
September 26, 2005 04:30PM
2223
November 03, 2005 05:42AM
3235
November 03, 2005 06:56AM
1916
November 03, 2005 04:37PM
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.