Re: Order of fields in a table.

From: Quarkman <quarkman_at_nowhere>
Date: Sat, 5 Jul 2003 09:17:08 +1000
Message-ID: <3f060aec$0$728$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F05FC7C.D6F813A_at_exxesolutions.com...
> Quarkman wrote:

> Of course if you are developing a new application using LONG you have
> demonstrated that you don't read and/or follow advice from Oracle as to
support
> for LONG and LONG RAW in the future.
>
> Anyone building a new table with LONG ... deserves what they get and CLOBs
> don't have this problem nor do IOT's.

IOTs do actually (that's the bit you snipped).

PCTHRESHOLD and INCLUDING requires you to order your columns appropriately: otherwise, what gets shunted to the overflow tablespace will be stuff you wanted left behind in the IOT.

You can snip all you like, but they remains the facts.

~QM Received on Fri Jul 04 2003 - 18:17:08 CDT