difference between create synonym and create view

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 21 Dec 2009 06:55:01 -0800 (PST)
Message-ID: <210856.89498.qm_at_web65701.mail.ac4.yahoo.com>

Does anyone know what is different between following two statement:
  1. create view aaa as select * from bbb.bbb;
  2. create synonym from aaa;

My friend told me "create synonym" will save resource than 'create view". Is it true?


Received on Mon Dec 21 2009 - 08:55:01 CST

Original text of this message