Am Mittwoch, 21. Dezember 2005 21:27 schrieb Klein Balázs: > Or should I instead create a view that contains only the biodata and select > from that? But will postgres use the indexes than? Would that be a better > approach? Whether the query is executed by a view or typed in in its full form by hand is completely irrelevant to the question whether indexes are used or should be created. Views do not optimize anything.