PK Debate
From: PDQ News <calvinfab_at_yahoo.com>
Date: Mon, 2 Oct 2000 23:10:04 -0500
Message-ID: <E0F13271F2D5E4F3.27356CB196F5C4D5.5635AA4DA2974168_at_lp.airnews.net>
Date: Mon, 2 Oct 2000 23:10:04 -0500
Message-ID: <E0F13271F2D5E4F3.27356CB196F5C4D5.5635AA4DA2974168_at_lp.airnews.net>
Hi,
When designing tables for Oracle 8i or SQL Server 7.0, is there a preference to using a single-column primary key (like an Identity value or sequenced value) for tables or multiple columns?
How does this affect joins and balancing of b-tree indexes and the speed of index lookups?
I am to understand that optimizers (of Oracle and SQL Server) when choosing an index look at the distribution of unique values or column cardinality.
Any insight is appreciated.
Calvin Fabre
Shiptrax, Inc.
--Received on Tue Oct 03 2000 - 06:10:04 CEST