Re: LONG vs. Multiple VARCHAR2

My biggest problems with LONG fields it that they have a nasty habit of making SQL*Loader puke from time to time. I like the one respondant's answer of making your LONGs in their own tables with a key. That way when you do selects with no long fields, your full table scans will be much quicker. Received on Sun Aug 20 1995 - 00:00:00 CEST