Hello,
  Are the SQL Server statistics different than DBISAM ?

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr

>   Are the SQL Server statistics different than DBISAM ?

I assume you mean MS SQL Server statistics?

if so then yes in implementation but essentially doing the same thing -
helping to optimize queries and other operations.

Tim can talk more about it but since we're talking different products the
stats are not comparable in any meaningful way in my view.

DBISAM (like ms sql) automatically does include statistics with indexes
unless you specify the NOKEYSTATS clause.

More info on the filter optimization - which does briefly talk about
statitics - is available from Advanced Topics -> Filter Optimization  (eg.
http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=r&version=2009&category=2&topic=6)

Unlike MS SQL i don't think you can display the current statistics for an
index (or table).

Cheers,
Raul



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4257 (20090718) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Michael,

<< Are the SQL Server statistics different than DBISAM ? >>

In the implementation, yes.  I believe that SQL Server uses a histogram or
for the statistics, whereas DBISAM uses simple counts associated with the
various index nodes to provide exact row counts for a given value or range
of values.

Here's some more information from a Google search:

http://blog.namwarrizvi.com/?p=193

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Tim,

> << Are the SQL Server statistics different than DBISAM ? >>
>
> In the implementation, yes.  I believe that SQL Server uses a histogram or
> for the statistics, whereas DBISAM uses simple counts associated with the
> various index nodes to provide exact row counts for a given value or range
> of values.
>
> Here's some more information from a Google search:
>
> http://blog.namwarrizvi.com/?p=193

http://technet.microsoft.com/en-us/library/dd535534.aspx

Summary of Statistics Features

SQL Server 2008 has a number of features for maintaining statistics. The
most important one is the ability to automatically create and update
statistics. This feature, also called auto stats, is on by default
starting in SQL Server 2000.

....

Interesting ...
Thanks guys ...

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr