Oracles Analyze Table statement equivalent ?

• Shivsam

  Old Hand

  Points: 330

  More actions

  October 9, 2004 at 5:52 am

  #59962

  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,

  ShivSam

• Xanderno

  SSC Veteran

  Points: 220

  More actions

  October 9, 2004 at 9:24 am

  #526045

  I believe what you're looking for is: UPDATE STATISTICS test WITH SAMPLE 2500 ROWS