Re: Index query - monotonically increasing columns

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 22 May 2003 19:22:15 +1000
Message-ID: <Yt0za.39669$1s1.563027@newsfeeds.bigpond.com>

[huge snip]
> > Incidentally, reversing is not necessariily the best way of dealing with
it,
> > either. A nice hash partition on the index might be a better approach,
since
> > that will also ensure that an ascending number ends up being inserted
into a
> > variety of different segments (ie, partitions).
> Hash partitions - they are Oracle 9i though are they not? This app
> will be 8i and 9i based (I know about 8i, but some things are not
> under my control !)

Hash partitions were invented in 8i. So you'll be good to go in both versions.

[Did I really call them 'monotonously' incrementing????! I suspect an editorial slip-up if so!! -at least, that's my excuse!!]

Regards
HJR Received on Thu May 22 2003 - 04:22:15 CDT