title: Diff between CTE and Volatile tables in Teradata
body: <p>Can anyone please explain difference between Common Table Expression(CTE)Tables and Volatile tables in which scenario they perform better.</p>
  
  <p>As we can create &amp; drop volatile tables as part of our SQL where exactly CTE will perform better while compare to Volatile tables?</p>