Andrzej Kaczmarczyk wrote:
Hi Carlos,
Does Provider have anything supporting sweeping databases and index
statistics recalculation?
And of course FirebirdSql.Data.Firebird.Services.FbStatistical .
For recomputing stats for index just deactivate and activate the index.
You can also try to use 'set statistics', but I'm not sure if it works
win provider.
BTW 'alter index ...' is better, because it's rebuliding the index tree
too, 'set statistics' is only recomputing stats.
PS: sorry for 2nd mail, my fault.
--
Jiri Cincura
http://www.cincura.net/
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
