Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8 and 8i default constraint behavior
Incidentally, I just thought I might mention that regardless of the structure of the rowid, trivium,as we all know, is simply a medieval university course of grammar, rhetoric, and logic. Apparently, this is because in Latin, trivium meant a place where three roads meet (yes, I'm struggling to find the connection, too. I guess they just thought that way in the 13th century).
What you are after (if, in fact you can be bothered!), is trivial, which as we all know comes from trivialis meaning "ordinary" or "commonplace".
Lord, what a wonder is the OED.
Regards
HJR
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3af94dff_at_news.iprimus.com.au...
> God, you're good!
> HJR
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:989415907.19375.0.nnrp-10.9e984b29_at_news.demon.co.uk...
> >
> > In a unique index, the rowid is stored
> > in a fixed location at the start of row.
> > In a non-unique index, the rowid is
> > appended to the index as a real column,
> > so it has to have a length byte prepended;
> > Oracle then treats the index as a unique
> > index using all the normal tools for handling
> > a string of (length)(value) pairs.
> >
> >
> > Here's another trivium (which I think is the
> > singular of trivia) on indexes -
> > The rowid stored in an index is 6 bytes,
> > unless it is a global index for a partitioned
> > object, in which case the rowid is actually
> > stored as 10 bytes (4 more bytes for the
> > object-id).
> >
> >
> > --
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > Practical Oracle 8i: Building Efficient Databases
> > Publishers: Addison-Wesley
> >
> > Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
> >
> >
> >
> > Howard J. Rogers wrote in message <3af93719_at_news.iprimus.com.au>...
> > >See, I knew you'd know!!
> > >
> > >Thanks Jonathan! (Incidentally, what's the extra byte?)
> > >
> > >Regards
> > >HJR
> > >
> >
> >
> >
>
>
Received on Wed May 09 2001 - 09:11:03 CDT