Re: [GENERAL] What is faster?

2001-03-30 Thread ADBAAMD
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 in

[GENERAL] What is faster?

2001-03-30 Thread Mihai Gheorghiu
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. Thanks, Mihai Gheorghiu ---(end of broadcast)-