sp_createstats in SQL 6.5?

sp_createstats in SQL 6.5?

Post by Ronnie Wagtervel » Tue, 22 Jun 1999 04:00:00



Hi,

On the microsoft site are some articles on the stored procedure
'sp_createstats' and 'sp_updatestats'. These procedures are used to create
or update the statistics used by the optimizer. It seems that these are only
available SQL server 7.0, is there an alternative in SQL 6.5?

Greetings,
    Ronnie

 
 
 

sp_createstats in SQL 6.5?

Post by Alexander Tarasu » Tue, 22 Jun 1999 04:00:00


update statistics statement

-------------------------------------------
Alexander Tarasul
Microsoft Certified Solution Developer(SQL Server,VB)
Certified Borland Delphi Client Server Developer

http://pages.ripco.com/~shleym
SQL Answers located at
http://pages.ripco.com/~shleym/sql_answers.htm

---------------


>Hi,

>On the microsoft site are some articles on the stored procedure
>'sp_createstats' and 'sp_updatestats'. These procedures are used to create
>or update the statistics used by the optimizer. It seems that these are
only
>available SQL server 7.0, is there an alternative in SQL 6.5?

>Greetings,
>    Ronnie