[MonetDB-users] What is optimizer_stats()

Martin Kersten Martin.Kersten at cwi.nl
Wed Oct 3 23:06:14 CEST 2007

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 
Just run it once against your server is sufficient to make this function 

regards, good luck, Martin

More information about the users-list mailing list