Re: No more than 1 LONG in a table question
From: Rick Rutt <rrutt_at_delphi.com>
Date: 1995/09/05
Message-ID: <B-OiUlk.rrutt_at_delphi.com>#1/1
Date: 1995/09/05
Message-ID: <B-OiUlk.rrutt_at_delphi.com>#1/1
Doug Harris <ah513_at_FreeNet.Carleton.CA> writes:
> Actually, moving all of your LONG columns to their own table (perhaps
>joined by an artificial sequential key) can be good for performance if
>you do a lot of full table scans. It drastically reduces the size of
>your original table.
This approach also allows you to use INSERT INTO ... SELECT FROM ... notation to copy records for the main table(s), since the Long columns are not present.
- Rick --
(Rick Rutt is a system architect living and working in Midland, Michigan.) Received on Tue Sep 05 1995 - 00:00:00 CEST