Re: llogspace required

> Is there anyway to estimate the size of logspace required , if I have to = > delete records from different tables? The data size could be rowsize* = > number of records, what other factors do I need to consider? Something like 12 (or 16, I forget) + rowsize for each row, plus 16 (or 20) + index size for each index for each row, plus overhead for stuff like B-tree balancing, checkpoints. And remember that this must all fit in 50% of your logical logs, or the transaction rolls back. And remember that your first log may not be (probably won't be) at 0% when you start the transaction, and all the space that's used counts against you as well, toward the 50%. The fewer logs you have, the more of an issue this will be; e.g. if you only have 3 logs, and the current one is at 99% full when your transaction starts, you only get 1/2 of the next log before your transaction rolls back. June -- june_t@hotmail.com Grounded in Palo Alto, living on brownies