Results 1 to 4 of 4

Thread: analyze index in Ms SQL

  1. 07-21-2003, 10:20 AM #1
    marina_sirota
    marina_sirota is offline Registered User
    Join Date
    Jun 2003
    Location
    Israel
    Posts
    17

    analyze index in Ms SQL

    Hello, friends!
    sorry for the stupid question:
    I created a new index on table and I'm looking to a command equal to "Analyze table ", "Compute statistics "in Oracle
    to check if that index is usefull.

    Thank you very much in advance.
    Reply With Quote Reply With Quote
  2. 07-21-2003, 10:27 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Check books online

    Use execution plan. (select a query and press CTRL + L)


    DBCC showcontig

    DBCC SHOW_STATISTICS

    DBCC indexdefrag
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-21-2003, 12:13 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use

    UPDATE STATISTICS tablename

    or

    sp_updatestats

    to update stats for all tables in current database.
    Reply With Quote Reply With Quote
  4. 07-22-2003, 01:38 AM #4
    marina_sirota
    marina_sirota is offline Registered User
    Join Date
    Jun 2003
    Location
    Israel
    Posts
    17
    thank you very much friends!!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules