| From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> |
| Cc: | "John Meyer" <john(dot)l(dot)meyer(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: counting query |
| Date: | 2007-01-28 15:29:27 |
| Message-ID: | 87bqkjrwyw.fsf@suzuka.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> writes:
> What would have been better without surrogate keys all-over:
> * Easier to write complex queries with much fewer tables to be queried.
> * Much faster query performance, as fewer tables need to be referenced.
> * Better integrity enforcement with simple foreign key constraints.
Not this debeta again. ;)
Surrugate vs natural keys shouldn't make a difference in how many
yables you have--they depends on the degree of normalization. Sounds
like you denormalized your database and happened to eliminate
surrogate keys at the same time. Using that to say "surrogate keys
are bad" is kind of misleading.
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2007-01-28 15:32:15 | Re: counting query |
| Previous Message | Joris Dobbelsteen | 2007-01-28 15:10:30 | Re: counting query |