Re: Very Large Table extending after mass deletes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 3 Feb 2000 06:58:34 -0000
Message-ID: <949561441.4131.0.nnrp-12.9e984b29@news.demon.co.uk>

No, It applies particularly to long LONGs, and then only when the table is subject to delete/insert cycles.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Greg Stark wrote in message
<874sbrasay.fsf_at_HSE-Montreal-ppp33976.qc.sympatico.ca>...
>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> writes:
>
>> Tables with LONGs in them tend to be major pains.
>
>We have a table with a LONG column in it (the developer was used to MSSQL
>which had a 256 character limit on varchars) but we don't really use it for
>anything big, 100-200 bytes is normal. Should we be worried and rebuild
this
>table? or are your comments and others that I've seen only relevant for
people
>who are actually storing lots of data in LONGs?
>
>--
>greg
Received on Thu Feb 03 2000 - 00:58:34 CST