Hi List !

Is it true that it is a bad idea to store BLOB's together with other
fields in 1 table (performance) ? Is it better to store those fields
in a seperate table ?

In case it is bad : is it only bad if that field is part of the SELECT
statement ? Or is it also bad even if the field is not included in the
SELECT ?

And last : What if there is no value given for the BLOB for a
particular record, is the database assigning space for it anyway ?

Thanks a lot and best regards,

Mary Ann