[PERFORM] Performance issue with nested loop

2007-08-29 Thread Jens Reufsteck
Hi all, I'm having a strange performance issue with two almost similar queries, the one running as expected, the other one taking far more time. The only difference is that I have "uniid in (10)" in the normally running query and "uniid in (9,10)" in the other one. The number of rows resulting fro

[PERFORM] Performance issue with nested loop

2007-08-29 Thread Jens Reufsteck
Hi all, I'm having a strange performance issue with two almost similar queries, the one running as expected, the other one taking far more time. The only difference is that I have "uniid in (10)" in the normally running query and "uniid in (9,10)" in the other one. The number of rows resulting fro