OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » too many views

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

too many views [message #211252]

Wed, 27 December 2006 10:53

mjschwenger
Messages: 137
Registered: July 2005
Location: US

Senior Member

I have a question on justifying the number of the views created on a very heavy transactional database and the possible performance degradation.
We have multiple views that do a good job - like address, name, transactions, etc. that provide a valuable summary information about the item in one call. But in the last year, there were multiple new views created on top of the base views just to select a specific date range from the existing view, or a separate view just to select a home address, etc.

How reasonable is this? May the high number of views cause performance problems? What is the overhead for the database of supporting all of these views?

Thanks a lot, mj

Report message to a moderator

Re: too many views [message #211254 is a reply to message #211252]

Wed, 27 December 2006 11:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I was just about to write a wordy response with some demonstration.
But searched first. As usual, Tom has written it his own elegant style.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1353453813863

[Updated on: Wed, 27 December 2006 11:18]

Report message to a moderator

Re: too many views [message #211279 is a reply to message #211254]

Wed, 27 December 2006 15:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I couldn't resist posting this comment from document Mahesh suggested. Is it a Spanish translation of the transcript of Hungarian-speaking person's conversation with an Englishman (and both of them spoke French)? :

Unknown

ur prblm iz dat uv not dzkribed ne dtl (wht iz "business layer" mean?) such dat ne1 kn mak a guess as 2 wer ur pblm might B xcpt sumwer in ur .net code.

Report message to a moderator