Re: [MonetDB-users] Why does MonetDB take indexes not into account?

On Mon, Nov 26, 2007 at 09:49:53AM +0100, Markus Gritsch wrote:

On Nov 26, 2007 9:42 AM, Niels Nes wrote:

...

I will look into this problem, but changing the optimizer is always

Looking forward to it :)

any change I could have access to the test data set your using? This would make it much easier to test the performance improvements. Niels

...

with great causion as it may cause unwanted side effects (performance degredation) on other queries.

Reminds me of using Oracle where joining a completely unrelated table to a query (which motivated Oracle to use another optimizer) greatly sped up the select... :/

Good luck, Markus

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl