OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » DB tuning

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB tuning [message #204523]

Tue, 21 November 2006 02:59

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.

Report message to a moderator

Re: DB tuning [message #204717 is a reply to message #204523]

Tue, 21 November 2006 18:55

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: DB tuning [message #207901 is a reply to message #204717]

Thu, 07 December 2006 04:59

ataufique
Messages: 79
Registered: November 2006

Member

Hi...

should i create 2 table ????

Report message to a moderator

Previous Topic:	Doubt on Oracle Post-Wait Extension in Semaphore allocation
Next Topic:	query tunning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 00:15:57 CDT 2024