| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | indexes |
| Date: | 2003-02-28 15:47:13 |
| Message-ID: | 006d01c2df40$a9f34a70$de138f80@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I have three tables that are queried frequently together. I have indexes on the PK values in each table as these are the fields that are typically used in the where clauses. Do I need to also have indexes on the corresponding FK values to improve performance?
Thanks,
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tycho Fruru | 2003-02-28 16:31:10 | Re: Cross-database references |
| Previous Message | Bruno Wolff III | 2003-02-28 15:28:18 | Re: GRANT access on table fields |