[Monetdb-developers] How to know the database size and use indexes?
Hi,
I wonder if there is a way to get the size of a database (SQL/XQuery)? And I wonder if I can ask MonetDB (SQL/XQuery) to use a specific index explicitly?
Hi,
Sorry for bothering you. I wonder if anyone could kindly point to me a few related articles that I can find out the solutions?
Thanks, Mo
On Mon, Feb 1, 2010 at 4:16 PM, Mo Zhou mozhou@umail.iu.edu wrote:
Hi,
I wonder if there is a way to get the size of a database (SQL/XQuery)? And I wonder if I can ask MonetDB (SQL/XQuery) to use a specific index explicitly?
-- Thanks, Mo
On 04-02-2010 12:34:54 -0500, Mo Zhou wrote:
Sorry for bothering you. I wonder if anyone could kindly point to me a few related articles that I can find out the solutions?
you can just look at the disk size of the database directory
I think it's impossible to request a specific index to be used
On Mon, Feb 1, 2010 at 4:16 PM, Mo Zhou mozhou@umail.iu.edu wrote:
I wonder if there is a way to get the size of a database (SQL/XQuery)? And I wonder if I can ask MonetDB (SQL/XQuery) to use a specific index explicitly?
Thanks a lot!
On Thu, Feb 4, 2010 at 1:38 PM, Fabian Groffen Fabian.Groffen@cwi.nl wrote:
On 04-02-2010 12:34:54 -0500, Mo Zhou wrote:
Sorry for bothering you. I wonder if anyone could kindly point to me a few related articles that I can find out the solutions?
you can just look at the disk size of the database directory
I think it's impossible to request a specific index to be used
On Mon, Feb 1, 2010 at 4:16 PM, Mo Zhou mozhou@umail.iu.edu wrote:
I wonder if there is a way to get the size of a database (SQL/XQuery)? And I wonder if I can ask MonetDB (SQL/XQuery) to use a specific index explicitly?
The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
Fabian Groffen -
Mo Zhou