Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Stats
Wed, Jun 3 2009 9:13 PMPermanent Link

Sanford Aranoff
What is this new feature about? What are stats with indexes?
Thu, Jun 4 2009 2:02 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sanford,

<< What is this new feature about? What are stats with indexes? >>

Unless you have databases in the multi-GB range, there really is no
advantage to removing the index statistics.  They are there to support a lot
of useful features in DBISAM like logical record numbers, accurate record
counts with ranges, and accurate query I/O cost estimations, so removing
them has some serious downsides.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Jun 5 2009 2:31 PMPermanent Link

Sanford Aranoff
"Tim Young [Elevate Software]" wrote:
>
> Sanford,
>
> << What is this new feature about? What are stats with indexes? >>
>
> Unless you have databases in the multi-GB range, there really is no
> advantage to removing the index statistics.  They are there to support a lot
> of useful features in DBISAM like logical record numbers, accurate record
> counts with ranges, and accurate query I/O cost estimations, so removing
> them has some serious downsides.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com

Well, my question is that does it pay to upgrade to get
stats? I could not find any info on your website.
Fri, Jun 5 2009 4:04 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sanford,

<< Well, my question is that does it pay to upgrade to get stats? I could
not find any info on your website. >>

You're not getting the index statistics, you're getting the ability to
remove them from any desired index.  As to whether you need that ability, it
really depends upon if you are going to have DBISAM tables in the GB range
or higher.

As for paying, you're actually paying for a support plan, if your support
plan has expired, so you're actually paying for *any* minor releases to
DBISAM over the next year.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image