[MonetDB-users] What is optimizer_stats()

Niels Nes Niels.Nes at cwi.nl
Wed Oct 3 23:07:16 CEST 2007


On Wed, Oct 03, 2007 at 01:51:04PM -0700, Pranav Vaidya wrote:
> 
> Hi,
> 
> I am new to MonetDB and I am trying to run the TPC-H benchmarks and I was
> able to successfully load and execute the benchmarks in MonetDB version 4. I
> also verified whether the tables were populated using Dbvis. However, what
> seems to fail is the lack of a function called optimizer_stats() in the
> run.all script. 
> 
> Is this a procedure or a function defined additionally which is needed. And
> why is it not present ? Do I need to run some additional scripts to have
> this run.all script go through successfully without any errors.

Indeed you need to load this extra function.

run the following command with a running server.
mclient -lsql < src/sql/stats.sql

The calls to optimizer_stats() are however only needed for the nightly testing. 
For running experminents simply remove these calls.

Niels
> 
> Thanks and Regards,
> Pranav.
> 
> 
> -- 
> View this message in context: http://www.nabble.com/What-is-optimizer_stats%28%29-tf4564307.html#a13027620
> Sent from the monetdb-users mailing list archive at Nabble.com.
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at 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 at cwi.nl




More information about the users-list mailing list