Rudi,
> Do you think an Index or Seq. scan should be used?
That was way too much data for way too simple a question. ;-)
The answer is: depends on how many rows you have. With any significant
number of rows, yes.
However, you probably only need to index the first 3-5 columns; that's
selective enough.
--
-Josh Berkus
"A developer of Very Little Brain"
Aglio Database Solutions
San Francisco
