Is there something I need to do to have postgres recognize the indexes I have just created. I see them when I do a \d tablename but when I do an explain on my queries it still states that it is doing a sequential scan.
Thanks
Jodi
_______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu