View previous topic :: View next topic |
Author |
Message |
danm Intermediate
Joined: 29 Jun 2004 Posts: 170 Topics: 73
|
Posted: Thu Nov 19, 2015 12:36 pm Post subject: View of a view |
|
|
I need to create a view joining tableA, Tableb, TableC and TableD. If there is alreay an exising ViewX joining tableA and TableB, I can create a view joining ViewX, TableC and TableD. Will the performance degrade on view of a view? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12359 Topics: 75 Location: San Jose
|
Posted: Thu Nov 19, 2015 12:44 pm Post subject: Re: View of a view |
|
|
danm wrote: | I need to create a view joining tableA, Tableb, TableC and TableD. If there is alreay an exising ViewX joining tableA and TableB, I can create a view joining ViewX, TableC and TableD. Will the performance degrade on view of a view? |
Danm,
As long as the views are only used for reading the data without any INSERT/UPDATE/DELETE you will not have a performance degradation even if you create a view based of another view.
Kolusu |
|
Back to top |
|
|
danm Intermediate
Joined: 29 Jun 2004 Posts: 170 Topics: 73
|
Posted: Thu Nov 19, 2015 1:36 pm Post subject: |
|
|
Kolusu,
Thanks. |
|
Back to top |
|
|
|
|