Thank you. So, the database on its own will collect selectivity statistics so that if there are multiple atomic conditions on a column, it will choose to apply the more selective one first? Thanks

----- Original Message ----- From: "Martin Kersten" To: "Communication channel for MonetDB users" Subject: Re: [MonetDB-users] Analyze Date: Tue, 19 Feb 2008 14:35:48 +0100

Dear Rahul

thank you for your interest in MonetDB. There is no such thing as ANALYZE or UPDATE STATISTICS. They are not part of the SQL 99 standard and its implementation would not make sense. The database performance continuous analysis to optimize execution using actual properties of the tables involved.

regards, Martin Rahul Chopra wrote:

...

Is there the equivalent of ANALYZE or UPDATE STATISTICS in MonetDB? I tried both, but could not get them to work.

Thanks!

= embedded system UML 2.0-Based Software Engineering Using Model-Driven Development. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=b006f31a35aad88266245071...

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

= Sell Your Annuity If you are receiving payments from a structured settlement or annuity and need cash now, the Structured Settlement Alliance is here to help you get your cash now. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=fc012ccf36676d4eeec4d34f... -- Powered by Outblaze