Re: Table with Long datatypes?

This is a multi-part message in MIME format.

------=_NextPart_000_0012_01BFE9CB.3C42B1E0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

As far as LONG, etc. column types are concerned if they do not have to = be retrieved every time the other part of the row is retrieved (e.g. = when a query is evaluating the where clause expression which can not = include LONGs) you have significant gain in performance if you put LONG = in another table (not necessary as you pointed out in the tablespace) - = the LONGS would be read only for the presentation of the result set if = necessary. Received on Sun Jul 09 2000 - 16:29:28 CDT