| From: | "ADBAAMD" <adba(dot)amdocs(at)bell(dot)ca> |
|---|---|
| To: | "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What is faster? |
| Date: | 2001-03-30 18:29:56 |
| Message-ID: | 3AC4D0A4.1000008@bell.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mihai Gheorghiu wrote:
> I have a short table (10 records) with a primary key column.
>
> What primary key column data type will make search faster: int2 or char?
> What about char(n) n=2,3...?
> I'm looking for speed, as that search is very frequent.
With such a short table, won't a index lookup actually make your query
slower?
--
_
/ \ Leandro Guimarães Faria Corsetti Dutra +55 (11) 3040 8913
\ / Amdocs at Bell Canada +1 (514) 786 87 47
X Support Center, São Paulo, Brazil mailto:adbaamd(at)bell(dot)ca
/ \ http://terravista.pt./Enseada/1989/ mailto:leandrod(at)amdocs(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rose, Keith | 2001-03-30 18:42:52 | Globally Unique IDs? |
| Previous Message | Manuel Sugawara | 2001-03-30 18:21:23 | Re: Data access permission? |