Can view be called inside a view. [message #279212] |
Wed, 07 November 2007 06:33  |
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 #279219 is a reply to message #279215] |
Wed, 07 November 2007 06:48   |
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.
|
|
|
|