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