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!
Any luck in getting answer?
There's no difference, REPLACE simply CREATEs the view if it doesn't exist yet.