PostGreSql 7.4.3
Am I right in assuming that a foreign key on a table does not explicity create an index on that column on the foreign table? I can see via the \d on the table that the foreign key exists, but accessing the table on that column seems to use a sequential scan.
Regards,
Steve Tucknott
ReTSol Ltd
DDI: 01903 828769
|