Re: [SQL] Bad performing DELETE

2000-11-27 Thread Tom Lane
=?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= <[EMAIL PROTECTED]> writes: > I have two tables: t_haus is about 1400 row and t_host has 364000 entries. > Both tables are indexed on edvnr. I did a vacuum on my db and all indices > are rebuild. > I want to delete all Entries in t_haus where a row can

[SQL] Bad performing DELETE

2000-11-27 Thread Hans-Jürgen Schönig
> I have two tables: t_haus is about 1400 row and t_host has 364000 entries. Both tables are indexed on edvnr. I did a vacuum on my db and all indices are rebuild. I want to delete all Entries in t_haus where a row can be found in t_host. When using "delete from t_haus where t_haus.edvnr=t_host.e