Home » SQL & PL/SQL » SQL & PL/SQL » Can view be called inside a view.
Can view be called inside a view. [message #279212] Wed, 07 November 2007 06:33 Go to next message
saipol
Messages: 4
Registered: November 2007
Junior Member
hi Guys,

I would like to know will there be any performance issue, if i am going to read view inside a view (in a view sql i am reading another view aloing with other tables).

thanks
Sai
Re: Can view be called inside a view. [message #279214 is a reply to message #279212] Wed, 07 November 2007 06:37 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't think so, if you set QUERY_REWRITE_ENABLED as true.
I'm not sure it is only for Materialized views or not.

By
Vamsi

[Updated on: Wed, 07 November 2007 06:43]

Report message to a moderator

Re: Can view be called inside a view. [message #279215 is a reply to message #279212] Wed, 07 November 2007 06:37 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
As far as I'm aware, no. Do you have any reason to believe that would cause performance issues?
Re: Can view be called inside a view. [message #279218 is a reply to message #279212] Wed, 07 November 2007 06:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
A view is just a query whose text is stored in the database.
So it is the same thing as creating your view using a subquery.
The problem is the same one: if it is too complex Oracle cannot merge it.

Regards
Michel
Re: Can view be called inside a view. [message #279219 is a reply to message #279215] Wed, 07 November 2007 06:48 Go to previous messageGo to next message
saipol
Messages: 4
Registered: November 2007
Junior Member
I have a very complex sql, where i am using view as one of the source to that sql, when i am executing the sql it is working fine, when i am trying do the count of recrods through toad, i am getting error:

out of process memory when trying to allocate 119808 bytes.
Re: Can view be called inside a view. [message #279220 is a reply to message #279219] Wed, 07 November 2007 06:51 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe a TOAD error unless you an ORA code.
Try it with SQL*Plus.

Regards
Michel

[Updated on: Wed, 07 November 2007 06:52]

Report message to a moderator

Previous Topic: storing log of sql statements
Next Topic: months_between
Goto Forum:
  


Current Time: Sat Feb 15 14:20:48 CST 2025