db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Leroux <s...@wanadoo.fr>
Subject Re: Inserts are out of order
Date Fri, 11 Sep 2009 10:36:16 GMT
Knut Anders Hatlen a écrit :
> [...] It is also possible to use optimizer overrides[2] to prevent
> the optimizer from using the index, in which case you'll get the rows
> in the order they are stored in the base table.
In that case, isn't there any chance that an INSERT will re-use the 
space freed by a previous DELETE? Thus, the "file order" will no longer 
be the "insert order".

Website: http://www.chicoree.fr

View raw message