If you dont want to help me don't read this.
I'm new in PostgreSQL but I want to lern.
I don't know exactly what make my M$ Access faster.
Example
create table firma ( id int4 unique, data abstime, who varchar(50))
who is first name plus last name;
The table I use with M$ Access.
He have about 65.000 rows.
When I know only last name and want to find the row (by who) it's make
very long time.
I have index for who .
That is may setings in ODBC Driver.
Disable Genetic Optimizer - True
KSQO - True
Recognize Unique index - True
Use Delclare/Fetch - True
Parse Statment - True
Maximum
Text as LongVarChar - True
Bools as Char - True
Cache Size - 20000 :-)
Max Varchar - 254Max longVarchar 8190
Protocol 6.4
Show Column - True
PostgreSQL 6.4.2
Help Me