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@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
------------------------------------------------------------------------- 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@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.