Re: Insert if exists
Posted by: Peter Brawley
Date: January 18, 2016 05:44PM

> Would the record still be unique if I run the script?

A primary or unique index on all table columns would be unmanageable if there are more than three or so columns. Decide which address columns are crucial for uniquenesss and make those the primary key, or a unique key if there is already a surrogate (auto)_increment) primary key.

For remaining columns, if nulls are allowed it's more efficient to decalre them default null than to manage code that sets them to null.

Options: ReplyQuote

Written By
January 03, 2016 07:50AM
January 03, 2016 12:46PM
January 04, 2016 03:29AM
January 04, 2016 03:52AM
January 04, 2016 04:39AM
Re: Insert if exists
January 18, 2016 05:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.