All Forums General
umakathir 32 posts Joined 09/06
15 May 2015
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!

umakathir 32 posts Joined 09/06
21 May 2015

Any luck in getting answer?

dnoeth 4628 posts Joined 11/04
21 May 2015

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

Dieter

You must sign in to leave a comment.