I've this view:
create or replace view catalog_promosimple_v as
select p.PromoSimpleID,
p.IsPromo, p.Percent, p.OnListPrice, p.Vendible,
p.OnStock, p.Dist, p.PromoStart, p.PromoEnd, pi.ItemID, pi.Discount
from catalog_promosimple p
join catalog_promosimpleitem pi on
On Wed, Mar 18, 2009 at 2:40 PM, Ivan Sergio Borgonovo m...@webthatworks.it
wrote:
If the view is just an alias for the SQL as text and it is not
interpreted at creation time...
This assumption is wrong. A view is compiled at creation time, and the
compiled version of the view is used in