[MonetDB-users] What is optimizer_stats()

Pranav Vaidya pranav.vaidya at gmail.com
Wed Oct 3 23:26:01 CEST 2007


Hi Neil,

Thanks 

I got the statistics I was interested in. 

Regards,
Pranav.

Niels Nes wrote:
> 
> 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
> 
> -------------------------------------------------------------------------
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/What-is-optimizer_stats%28%29-tf4564307.html#a13028238
Sent from the monetdb-users mailing list archive at Nabble.com.





More information about the users-list mailing list