Re: PK vs Unique index

From: David Cressey <dave_at_dcressey.com>
Date: 17 Jan 2002 08:19:27 -0800
Message-ID: <213b986d.0201170819.16b1ffae@posting.google.com>

Dirk Gomez <usenet_at_dirkgomez.de> wrote in message

> Could you explain this in a little more detail please?

Just by way of example there is another database engine, also offered by the Oracle corp. Called Oracle Rdb.

In Oracle Rdb, declaring a primary key does NOT automatically cause the creation of an index structure to reflect the PK.

Oracle experts sometimes overlook this fact, when creating Rdb databases, and the result is sometimes unnecessary table scans.

For more info on Oracle Rdb, you can visit www.oracle.com/rdb Received on Thu Jan 17 2002 - 10:19:27 CST