Re: Re: using big primary keys v/s small primary keys

From: <mike_donnelly_uk_at_yahoo.co.uk>
Date: Mon, 10 Sep 2001 12:29:04 GMT
Message-ID: <3b9cb21d.1216.1804289383_at_opus.randori.com>

Not true. This taken from the Oracle Concepts manual...

"When you create an index, Oracle fetches and sorts the columns to be indexed, and stores the rowid along with the index value for each row."

> Hi there,
>
> Index is created in BTree and ROWID alone are stored at
> the leafs
> of the index, NOT the value itself.
>
>
> Allan W. Tham
> DBA
Received on Mon Sep 10 2001 - 14:29:04 CEST

This message: [ Message body ]
Next message: godmann: "Re: using big primary keys v/s small primary keys"
Previous message: Sam Herman: "escape characters in oracle functions"
Maybe in reply to: Narasimha Murthy: "using big primary keys v/s small primary keys"
In reply to godmann: "Re: using big primary keys v/s small primary keys"
Next in thread: godmann: "Re: using big primary keys v/s small primary keys"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message