UPSERT INTO

and REPLACE are data modification operations that don’t require a prefetch and run faster and cheaper than other operations because of that.

Examples