Hello, malte!

Monday, October 14, 2013, 12:22:00 PM, you wrote:

mtec> the indices are used, but only the server knows why he scans the whole table.
mtec> Statement Statistics: Reads: 1,0 GB Inserts: 25 Indexed Reads:
mtec> 25 Writes: 180,0 KB Updates: 0 Sequential Reads: 8.259.025
mtec> Deletes: 25 Table Scan: 100%

mtec>
mtec> btw: after backup and restore the behavior is ok, but that can't be the solution...

Garbage? Visit seminar about transaction control in applications at
Siegburg (22 Nov) or Prague (25 Nov).

--
Dmitry Kuzmenko, www.ib-aid.com