Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the IDERA SQL Admin Toolset Launchpad, and then click Index Analyzer.
  2. Specify the SQL Server instance whose indexes you want to check.
  3. Check Load Selectivity while loading Statistics to load selectivity statistics now.
  4. Click Load Statistics.
  5. View the index data displayed on the Index Statistics tab. To sort the indexes, use the View Options in the right pane.
  6. To view details about the index columns, click the Column Statistics tab.
  7. To view index data for a specific table, expand the instance node in the tree pane, and then click the appropriate table.
  8. To recalculate the statistics using a sample percentage of rows, click Update Statistics (using Sampling). To recalculate statistics using all rows, click Update Statistics (using Full Scan).
  9. If you want to save the results, copy the list to clipboard, or save the results as an XML or CSV file.

 

IDERA SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...