Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
SQL Server Statistics vs DBISAM Statistics ? |
Sat, Jul 18 2009 7:11 PM | Permanent Link |
Charalampos Michael | Hello,
Are the SQL Server statistics different than DBISAM ? -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr |
Sat, Jul 18 2009 11:47 PM | Permanent Link |
"Raul" | > 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 |
Mon, Jul 20 2009 11:13 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.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 |
Mon, Jul 20 2009 8:00 PM | Permanent Link |
Charalampos Michael | 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 |
This web page was last updated on Friday, April 26, 2024 at 06:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |