>> Only 130 rows out of the 30000 have ARCHIVED = 0
> in this case i would suggest a partial index:
> create index <indexname> on <tablename> (archived) where archived = 0;
Thanks, Andreas.
Sorry for the confusion about the table names.
The hint with the partial index sounds as it could solve the problem. I will test it.
Regards
Jürgen