Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <43553F60.5080704@Sourcery.Org>
Date: Tue, 18 Oct 2005 11:30:56 -0700
From: Satheesh Bandaram <satheesh@Sourcery.Org>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: How to update cardinality statistics
References: <4353EA29.7070406@softhome.net> <4353ECBF.8080107@Sourcery.Org>
 <4353F381.4090705@softhome.net>
In-Reply-To: <4353F381.4090705@softhome.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Why exactly do you need to know? Do you suspect they are wrong?

The row count info is stored internally, not in SYS.SYSSTATISTICS.
Statistics table contains some more additional statistics, which are
collected during index creation. (or backing index creation) If you
create an index on your table, you would see a row there.

Satheesh

Radovan Biciste wrote:

> Hello Satheesh,
> I'm not sure why I missed that part of documentation, sorry.
> I've checked SYS.SYSSTATISTICS and it is empty.
> In the documentation there is also note "If statistics are turned off
> system wide".
> Is there any way how to check that my statistics are up to date or at
> least existing ? I'm running embedded server.
> Thank you,
> Radovan
>
>
> Satheesh Bandaram wrote:
>
>> Take a look at Tuning Derby manual page:
>> http://db.apache.org/derby/docs/10.1/tuning/ctunstats848901.html
>>
>> This provides several ways to update cardinality information.
>>
>> Satheesh
>>
>> Radovan Biciste wrote:
>>
>>> Hello,
>>> I'm very new to derby. I was looking how to update cardinality
>>> statistics. I have joins between tables with couple hundreds of rows
>>> and about 600 thousands of rows. I'm using embedded server version
>>> 10.1.1 .0.
>>> Here is what I've found so far:
>>> 1. UPDATE STATISTICS FOR TABLE mytable is giving me a syntax error.
>>> Should work on Cloudscape though.
>>> 2. SYSCS_UTIL.SYSCS_COMPRESS_TABLE should update statistics but does
>>> not make too much sense as I do only inserts. It would take tooo much
>>> time.
>>>
>>> Am I missing something ?
>>> Thank you very much,
>>> Radovan
>>>
>>>
>>>
>>
>>
>
>
>