On Sat, Mar 06, 2010 at 07:27:09PM +0530, anshul gangwar wrote:

how can we get the estimate of the size of result of query based on any two attributes with varying rangeAnshul

Well, I guess you'd need to browse the related research literature for XML/XQuery cost modeling / result size estimation techniques --- however, to my knowledge that area is not yet as well charted and understood as cost modeling / result size estimation for relational algebra and SQL. Of course, the details highly depend on your XML document structure and data distribution as well as the shape and characteristics of your XQuery queries ... Stefan

On Sat, Mar 06, 2010 at 11:32:03AM +0530, anshul gangwar wrote:

...

--- On Fri, 5/3/10, Martin Kersten wrote:

From: Martin Kersten Subject: * Re: [Monetdb-developers] need help in monetdb xquery interface To: "anshul gangwar" Date: Friday, 5 March, 2010, 11:26 PM

anshul gangwar wrote:

...

hello ,            I want to know whether there is any expression or command or anything equivalent to explain sql construct. Also What is the way to There is material for you to study on the website: http://monetdb.cwi.nl/SQL/Documentation/SQL-Runtime-Features.html http://monetdb.cwi.nl/SQL/Documentation/EXPLAIN-Statement.html#EXPLAIN-State... get histogram statistics i.e way to find that histogram exists on attribute or not through Xquery interface. not through sql . MonetDB does not rely on separate statistics tables.

...

  Please reply as soon as possible.

thank you.

Actually i want the xquery construct equivalent to sql explain construct and

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

Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!.

Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev

_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers

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