[Monetdb-developers] Fw: Re: need help in monetdb xquery interface
--- On Fri, 5/3/10, Martin Kersten <Martin.Kersten@cwi.nl> wrote: From: Martin Kersten <Martin.Kersten@cwi.nl> Subject: Re: [Monetdb-developers] need help in monetdb xquery interface To: "anshul gangwar" <anshul1886@yahoo.co.in> Date: Friday, 5 March, 2010, 11:26 PM anshul gangwar wrote:
Please reply as soon as possible.
thank you.
Actually i want the xquery construct equivalent to sql explain construct and so how it simulates histogram features i.e to get that percentage of query etc. Please reply as soon as possible. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Hi, to see the internals of the xquery compiler you can run "pf --help" and see all available options. There too many but there is an option to print the plan in different stages, such as xquery algebra, relational algebra, even the final produces MIL code. pf is the command line invocation of pathfinder (our xquery compiler). lefteris On Sat, Mar 6, 2010 at 7:02 AM, anshul gangwar <anshul1886@yahoo.co.in>wrote:
On Sat, Mar 06, 2010 at 11:32:03AM +0530, anshul gangwar wrote:
MonetDB/XQuery does not provide such feature. To see the equivalent of the SQL EXPLAIN output, i.e., the MIL plan generated from your XQuery query, you need to use the Pathfinder stand-alone compiler "pf"; see `pf --help` and/or `pf --fullhelp` for details.
so how it simulates histogram features i.e to get that percentage of query etc.
Like MonetDB/SQL also MonetDB/XQuery does not rely on separate statistics such as histograms. Stefan
Please reply as soon as possible.
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
--- On Sat, 6/3/10, Stefan Manegold <Stefan.Manegold@cwi.nl> wrote: From: Stefan Manegold <Stefan.Manegold@cwi.nl> Subject: Re: [Monetdb-developers] Fw: Re: need help in monetdb xquery interface To: "anshul gangwar" <anshul1886@yahoo.co.in> Cc: monetdb-developers@lists.sourceforge.net Date: Saturday, 6 March, 2010, 3:23 PM On Sat, Mar 06, 2010 at 11:32:03AM +0530, anshul gangwar wrote:
MonetDB/XQuery does not provide such feature. To see the equivalent of the SQL EXPLAIN output, i.e., the MIL plan generated from your XQuery query, you need to use the Pathfinder stand-alone compiler "pf"; see `pf --help` and/or `pf --fullhelp` for details.
so how it simulates histogram features i.e to get that percentage of query etc.
Like MonetDB/SQL also MonetDB/XQuery does not rely on separate statistics such as histograms. Stefan
Please reply as soon as possible.
how can we get the estimate of the size of result of query based on any two attributes with varying range Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
participants (3)
-
anshul gangwar -
Lefteris -
Stefan Manegold