OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Which one best ?

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

Which one best ? [message #216523]

Mon, 29 January 2007 02:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi all,

I have a large quantity of data ( several millions ): several view's uses the same data

Approach 1:

Using one table, we can store all the data and several views can access that table

Approach 2:

Using several tables, we can store all the data and different sets of views can access these table

Which approach is the best one for performance?

Babu

Report message to a moderator

Re: Which one best ? [message #216526 is a reply to message #216523]

Mon, 29 January 2007 03:18

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Will you need to JOIN the views or all view will display only subset of column from the table?

If you must JOIN the views - then ONE table approach is (usually) better, because it eliminates the need for join, however it depends on the number of columns in your table and the row length as well.

HTH.

Report message to a moderator

Re: Which one best ? [message #216537 is a reply to message #216526]

Mon, 29 January 2007 05:17

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Yes joins also i used.

Thankyou

Report message to a moderator

Previous Topic:	DB Performace with different size drives.
Next Topic:	Optimizing Queries Against UNIONed View

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 11:20:10 CST 2024