U¿ytkownik "Jiri Cincura" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci news:[EMAIL PROTECTED] > 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. > Thank you very much. > > -- > Jiri Cincura > http://www.cincura.net/
CUIN Kaczy (had a cofee, feeling better, world is beautiful and life is great) ------------------------------------------------------- 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