Difference between REPLACE VIEW and CREATE VIEW

General
Enthusiast

Difference between REPLACE VIEW and CREATE VIEW

Can anyone assist me on the performance difference between REPLACE VIEW and CREATE VIEW? We always preferred to go for a REPLACE VIEW considering the usability but I am curious if it has any impact on the data dictionary. Thanks!

2 REPLIES
Enthusiast

Re: Difference between REPLACE VIEW and CREATE VIEW

Any luck in getting answer?

Senior Apprentice

Re: Difference between REPLACE VIEW and CREATE VIEW

There's no difference, REPLACE simply CREATEs the view if it doesn't exist yet.