Thread: index recognition

index recognition

From

Jodi Kanter

Date:

28 February 2003, 15:47:19

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