[MonetDB-users] What is optimizer_stats()

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


Hi Martin,

Thanks for your help. The script working now.

Regards,
Pranav

Martin Kersten wrote:
> 
> 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.
>>
>> Thanks and Regards,
>> Pranav.
>>
>>
>>   
> Hello, you don't need this call per se. It can be removed from the
> queries.
> Alternatively, you can find the optimizer_stats script in sql/src/sql 
> directory.
> Just run it once against your server is sufficient to make this function 
> known.
> 
> regards, good luck, Martin
> 
> -------------------------------------------------------------------------
> 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#a13028240
Sent from the monetdb-users mailing list archive at Nabble.com.





More information about the users-list mailing list