Gunnar, This type of where clause, that finds every single row, was the way we had to do it in 2.11, when DELETE required a WHERE clause. Beginning with version 3.0, you could do the same thing this way:
del rows fro transfg del rows fro verfg del rows fro ibub del rows fro hbfg del rows fro ibfg del rows fro trans del rows fro ib del rows fro ub del rows fro ubfg del rows fro hb del rows fro verifik It will be way faster, because it will just reset the beginning row/end row and counters to zero. It won't try to use indexes. That alone may solve your problem. It may be that you have a corrupted index. A PACK or RELOAD would also repair the indexes, and would squeeze out all the deleted space. Bill On Mon, 25 Nov 2002 18:44:45 +0100, Gunnar Ekblad wrote: >del rows fro transfg where kontonr is not null or kontonr is >null >del rows fro verfg where vernr is not null or vernr is null >del rows fro ibub where kontonr is not null or kontonr is >null >del rows fro hbfg where kontonr is not null or kontonr is >null >del rows fro ibfg where kontonr is not null or kontonr is >null >del rows fro trans where kontonr is not null or kontonr is >null >del rows fro ib where kontonr is not null or kontonr is >null >del rows fro ub where kontonr is not null or kontonr is >null >del rows fro ubfg where kontonr is not null or kontonr is >null >del rows fro hb where kontonr is not null or kontonr is >null >del rows fro verifik where vernr is not null or vernr is null ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
