| Subject | What type to use for primary key? |
|---|---|
| Author | jasajona |
| Post date | 2004-04-28T10:34:05Z |
Hello,
I am designing big database, where will be one generator that will
generate values for primary keys of all tables (so all records in all
tables will be unique). Integer is too small for primary key I decided
to use NUMERIC(15,1). Will it slow down performace? What is
generator's max size? What type to use?
I am designing big database, where will be one generator that will
generate values for primary keys of all tables (so all records in all
tables will be unique). Integer is too small for primary key I decided
to use NUMERIC(15,1). Will it slow down performace? What is
generator's max size? What type to use?