A view review in 60 seconds or less

  • Just another way of looking at something
  • Convenience (dev) and security (DBA)

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

What is happening here?

CREATE VIEW myview AS 
  SELECT * FROM mytable WHERE x > 12;

SELECT * FROM myview;

SELECT * FROM (SELECT * FROM mytable WHERE x > 12) AS myview;
  • Like a macro
  • Expanded in place
  • Rewrite - early in the system
      Last             TOC             Next