[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? -- Thanks, Mo
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
-- 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
-- Thanks, Mo
participants (2)
-
Fabian Groffen -
Mo Zhou