Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Indexing a compound PK, 2 x VARCHAR(24)??

Indexing a compound PK, 2 x VARCHAR(24)??

From: David Pattinson <dpattinson_at_enternet.com.au>
Date: Tue, 23 Nov 1999 10:43:05 +1100
Message-ID: <3839D509.841702AD@enternet.com.au>

How will Oracle build the index keys for a large compound PK? Does it only use the first n characters, or does it use the entire PK?

Thanks, David. Received on Mon Nov 22 1999 - 17:43:05 CST

This message: [ Message body ]
Next message: Scott A. Haas: "Re: OS command in PL/SQL block"
Previous message: David Pattinson: "Indexing a compound PK, 2 x VARCHAR(24)??"
Next in thread: Thomas Kyte: "Re: Indexing a compound PK, 2 x VARCHAR(24)??"
Reply: Thomas Kyte: "Re: Indexing a compound PK, 2 x VARCHAR(24)??"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US