Home » RDBMS Server » Performance Tuning » Which one best ?
Which one best ? [message #216523] Mon, 29 January 2007 02:40 Go to next message
babuknb
Messages: 1734
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
Re: Which one best ? [message #216526 is a reply to message #216523] Mon, 29 January 2007 03:18 Go to previous messageGo to next message
michael_bialik
Messages: 611
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.
Re: Which one best ? [message #216537 is a reply to message #216526] Mon, 29 January 2007 05:17 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Yes joins also i used.

Thankyou

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


Current Time: Fri Dec 09 07:50:58 CST 2016

Total time taken to generate the page: 0.13523 seconds