title: Is there any advantages related to Performance in Oracle View
body: <p>I'm learning about Oracle Views and I got the concept of views but little confused about performance.</p>
  
  <p>I was watching video and there I listen that oracle view can increase the performance. Suppose I have created view like below.</p>
  
  <pre><code>CREATE VIEW SALES_MAN
  AS
  SELECT * FROM EMP WHERE JOB='SALESMAN';
  </code></pre>
  
  <p>Ok now I have executed query to get SALES_MAN detail.</p>
  
  <pre><code>SELECT * FROM SALES_MAN
  </code></pre>
  
  <p>Ok now confusion start.
  I listened in video that once the above query <code>SELECT * FROM SALES_MAN</code> will be executed the DATA/RECORD will be placed into cache memory after hitting the oracle DB. and if I will execute same query( IN Current Session/Login ) Oracle Engine will not hit to Database and will give you record from CACHED-MEMORY is it right?</p>
  
  <p>But I have read on many websites that <strong>View add nothing to SQL performance</strong> <a href="http://www.dba-oracle.com/art_hints_views.htm" rel="nofollow">more</a></p>
  
  <p>Another Reference that says view not help in performance. <a href="https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1291563605946" rel="nofollow">Here</a></p>
  
  <p>So Views increase performance too or not?</p>