HI @all,
yesterday 22:00 MET i've started the request with "not exists". At 01:00 there was no result. At morning there was the result on the screen (count ID). I dont believe why the request with exists or not exists clause needs such a huge of time when in clause needs only a few seconds for the same result.
Now I am trying to delete the rows without a reference in table va_ums. Hope it will do it right.
For your information. The first select with count(id) is only for me to make shure that i am deleting the right rows.
with best rgds.
Albert
Albert Steckenborn schrieb:
Have tried not exists like shown:
select count(a.id) from bas_agnums a where not exists(select b.ag_id from va_ums b where b.ag_id=a.id group by b.ag_id)
When i commit the query i never get a result. Query hangs. Same with "exists" statement.
I don't believe what's wrong.
Hope for some hints.
with best rgds.
Albert
Albert Steckenborn schrieb:
hi folks,
following problem with actual maxdb release:
I have found no way to delete rows from table A without a reference in table B.
Table A 138000 rows
Table B 380000 rows
select count(ID) from bas_agnums where id in(select distinct id from bas_agnums,va_ums where bas_agnums.id=va_ums.ag_id(+) and va_ums.ag_id is null)
result: 55865
That is ok
Now i want to delete these rows with following statement:
delete from bas_agnums where id in(select distinct id from bas_agnums,va_ums where bas_agnums.id=va_ums.ag_id(+) and va_ums.ag_id is null)
result: No rows updated or deleted. No Result
That is wrong
Have tried a lot of ways and found nothing that is working.
Any hints?????
with best rgds.
Albert
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
