Oracles Analyze Table statement ?

Hi,
Below is an Oracle query used for cost optimization purpose :
analyze table test estimate statistics sample 2500 Rows;
Is there any equivalent for the above in SQL Server ?
Please advice,
Thanks,
SamWhy look for equivalent? Just convert to it!|||microsoft sql server automatically updates statistics as a default setting
you wouldnt have to manually create statistics unless you chose exceptions to the norm in your design.

for example
turning off autoupdatestats
creating composite indexes and creating statistics on the non leading columns
creating statistics on commonly searched columns that wouldnt normally warrant an index.

you can run the create statistics statement or the update statistics statements respectively

Check out Books Online in your SQL Server start menu folder
and search for statistics create stats or update stats.|||Below is an Oracle query used for cost optimization :

analyze table Customer list chained rows into CHAINED_ROWS;

Is there any equivalent for the above in SQL Server ?

Please advice,

Thanks,
Sam|||Is there any solutions?
I too need the equivalent for
the above query.

any help would be appreciated

With Regards
Sathya|||MS-SQL does not need the kind of maintenance that Oracle needs. It used to, years ago, but that time is long gone.

I could make up a number of suggestions, some of which would actually do something to improve optimization a bit, others would just do some disk i/o and make you feel good, but none of them are really needed anymore.

-PatP