Also there is possibly some merit in hash partitioning
the index rather than reversing it to avoid the
"leading edge" index problems that reverse keys are
targetted to resolve...
COnnor
- Jared Still <jkstill_at_cybcon.com> wrote: >
> I haven't either.
>
> The only make sense in a high activity OLTP
> database, and my OLTP
> experience is with 50 users and less. I dont' think
> most DBA's are on
> high activity OLTP systems anyway, so you don't
> hear too much
> about this kind of stuff.
>
> Jared
>
>
> On Friday 11 May 2001 23:57, Vikas Kawatra wrote:
> > Thanks Jared ! What I read makes a lot of sense-
> But what suprises me is -
> > that I haven't come across anyone really using
> Reverse key indexes for
> > Synthetic (surrogate Primary keys).
> >
> > Have you ?
> >
> > vikas
> >
> >
> > -----Original Message-----
> > From: Jared Still [mailto:jkstill_at_cybcon.com]
> > Sent: Friday, May 11, 2001 11:42 PM
> > To: ORACLE-L_at_fatcity.com; Vikas Kawatra
> > Subject: Re: Reverse key indexes
> >
> >
> >
> > Rather than re-invent the wheel, I'll let Steve
> Adams explain it.
> >
> > Besides, his explanation is better than the one I
> was going to give. :)
> >
> >
>
http://www.ixora.com.au/tips/design/synthetic_keys.htm
> >
> > Jared
> >
> > On Friday 11 May 2001 23:55, Vikas Kawatra wrote:
> > > Reverse key indexes are good for columns
> populated by sequence no's
> > > Does that mean that for surrogate Primary key's
> on OLTP systems - which
> >
> > are
> >
> > > populated by sequences - performance could be
> enhanced by creation
> > > reverse key indexes - rather than using the
> B*Tree unique indexes which
> > > are automatically created by Oracle.
> > >
> > > vikas
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat May 12 2001 - 04:50:45 CDT
