Re: [firebird-support] Performance of deleting records based on another table

2019-09-03 Thread Joost van der Sluis jo...@cnoc.nl [firebird-support]
On 8/28/19 6:47 AM, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Den 2019-08-17 kl. 12:51, skrev Joost van der Sluis jo...@cnoc.nl > [firebird-support]: > > > > Hi all, > > > > I finally realized today that I do not know how to prop

[firebird-support] Performance of deleting records based on another table

2019-08-27 Thread Joost van der Sluis jo...@cnoc.nl [firebird-support]
Hi all, I finally realized today that I do not know how to properly remove records based on another table. Suppose I have two tables, one with data (called BIG), and one table (SMALL) with only some id's that has to be removed from the BIG-table. I cannot get this to work, without having

[firebird-support] Performance of deleting records based on another table

2019-08-27 Thread Joost van der Sluis jo...@cnoc.nl [firebird-support]
Hi all, I finally realized today that I do not know how to properly remove records based on another table. Suppose I have two tables, one with data (called BIG), and one table (SMALL) with only some id's that has to be removed from the BIG-table. I cannot get this to work, without having