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

27 Nov 2007

      On 27/11/2007, Niels Nes  wrote:
...
...
On 27/11/2007, Niels Nes  wrote:
...
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.
No, they are somehow confidential, but I will try to produce some
dummy dataset, which the same behavior.
On Tue, Nov 27, 2007 at 10:32:52PM +0100, Markus Gritsch wrote:
thats fine, thanks
You can download a dataset from http://xile.org/le/data.zip
...
mclient.exe -lsql < DDL.sql
mclient.exe -lsql < DATA2.sql > log.txt
SELECT * FROM entry WHERE entry.note LIKE ('%kawilokare%')

SELECT * FROM entry, act WHERE
 entry.act_id = act.id AND
 act.is_closed = 0 AND
 entry.note LIKE ('%kawilokare%')

Both queries take about 0.5 seconds on my Notebook using MonetDB.

Markus