What is the proper syntax for using the "Insert ...not exists" code?
Is there a pdf or some other documentation floating around that I can get that would be a good reference for these types of questions?
I have a large table that I defined in the ddl as MultiSet. The table loads much faster now, but I still need to handle possible duplicate records (not just key because it is a NUPI, but entire record dups). What would be the best way to do this duplicate checking?