Hi Nicole,
Es sind zwar mittlerweile 20.000 Datensätze,
aber dennoch sollte das nicht so langsam sein.
welche Indexstrukturen liegen auf Deinen Tabellenspalten?
Wie stark projezieren diese?
Das kann leicht mehrere Zehnerpotenzen an Geschwindigkeit ausmachen ...
Viele Grüße
Michael
--
T'Pol: I apologize if I acted inappropriately.
V'Lar: Not at all. In fact, your bluntness made me reconsider some of my positions. Much as it has now.
(sh:| fo:} ch:] rl:( br:^ n4:( ie:% mo:) va:| de:/ zu:| fl:( ss:) ls:~ js:|)
T'Pol: I apologize if I acted inappropriately.
V'Lar: Not at all. In fact, your bluntness made me reconsider some of my positions. Much as it has now.
(sh:| fo:} ch:] rl:( br:^ n4:( ie:% mo:) va:| de:/ zu:| fl:( ss:) ls:~ js:|)