Colin,
Where can I read about the impact of having Primary Keys as VARCHAR? This
entails an 8 times overhead in Sybase, Oracle, and Microsoft for changing
PK values. It must rebuild the index versus and "update-in-place."
Buff Smith, Maestro
THE BLUES BUFFET BAND
310 280
Country_Code ASC
);
CREATE TABLE Validation_Codes_State (
State_Code CHAR(2) NOT NULL,
State_Name CHAR(128) NOT NULL,
PRIMARY KEY (State_Code)
);
CREATE UNIQUE INDEX XPKValidation_Codes_State ON Validation_Codes_State
(
State_Code ASC
);
Buff Smith, Proje