Home » RDBMS Server » Performance Tuning » DB tuning
DB tuning [message #204523] Tue, 21 November 2006 02:59 Go to next message
ataufique
Messages: 79
Registered: November 2006
Member
I am migrating my ingres DB to Oracle...
Query is
I have a main table with 50 columns and getting 50,000 records a day.
out of this 50 columns 6 columns gets only 20,000 records a day..
Should i pull this 6 column and build another table which will be updated with trigger when ever reqd or should i keep this
in the main table only.
Re: DB tuning [message #204717 is a reply to message #204523] Tue, 21 November 2006 18:55 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
If the table is already in 3rd Normal form, then leave it alone.
If the table is NOT already in 3rd Normal Form, fire the data architect who designed it.
Re: DB tuning [message #207901 is a reply to message #204717] Thu, 07 December 2006 04:59 Go to previous message
ataufique
Messages: 79
Registered: November 2006
Member
Hi...

should i create 2 table ????
Previous Topic: Doubt on Oracle Post-Wait Extension in Semaphore allocation
Next Topic: query tunning
Goto Forum:
  


Current Time: Sun Dec 04 14:37:58 CST 2016

Total time taken to generate the page: 0.06630 seconds