affect of view on join on select statement

affect of view on join on select statement

 

  

Hello gurus
1. Does any body knows if view on join between 2 tables can affect the
performance of select that done on it compare to same statement that done on
original table?
2. Does oracle optimizer consider view ,if it appears in the select, in
choosing the execution plan

Aviv Cohen
DBA
mailto:[Email Address Removed]Oracle LazyDBA home page