Hi,
can you show some sample?And what indexes have  you created?Can you show plan 
for both queries and real queries itself?What filter "where" are you using?
I am really interested because i have compared both queries with much more 
populated tables and i have got better results time, fetches and much bigger 
difference was memory usage.
Regards,Karol Bieniaszewski
null
  • RE: [firebird-... Omacht András aoma...@mve.hu [firebird-support]
    • Re: [fire... Gabor Boros mlngl...@bgss.hu [firebird-support]
      • RE: [... Omacht András aoma...@mve.hu [firebird-support]
        • R... Gabor Boros mlngl...@bgss.hu [firebird-support]
          • ... Omacht András aoma...@mve.hu [firebird-support]
      • Re: [... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
        • R... Gabor Boros mlngl...@bgss.hu [firebird-support]
          • ... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
            • ... Gabor Boros mlngl...@bgss.hu [firebird-support]
              • ... Gabor Boros mlngl...@bgss.hu [firebird-support]
  • Re: [firebird-... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    • Re: [fire... Gabor Boros mlngl...@bgss.hu [firebird-support]
  • Re: [firebird-... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    • Re: [fire... Gabor Boros mlngl...@bgss.hu [firebird-support]
      • Re: [... 'livius' liviusliv...@poczta.onet.pl [firebird-support]

Reply via email to