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@virginia.edu