Home » RDBMS Server » Performance Tuning » too many views
too many views [message #211252] Wed, 27 December 2006 10:53 Go to next message
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
Re: too many views [message #211254 is a reply to message #211252] Wed, 27 December 2006 11:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: too many views [message #211287 is a reply to message #211279] Wed, 27 December 2006 16:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Must be attempted mock on the posting he was responding to.
Re: too many views [message #211335 is a reply to message #211287] Thu, 28 December 2006 00:35 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It wasn't Tom Kyte who said this, but an unknown discussion participant.
Previous Topic: how to use dbms_system.set_sql_trace_in_session with 10046 level 12
Next Topic: Tune the Update Process
Goto Forum:
  


Current Time: Sat Dec 10 14:28:50 CST 2016

Total time taken to generate the page: 0.31349 seconds