...
SQL Query Tuner looks at the columns that have histograms and using statistics tries to determine whether the column is a good or bad candidate for a histogram and presents this information on the Column Statistics and Histograms tab.
Image Modified
The row shading indicates the following:
...
Info |
---|
If you are gathering statistics for a column for which the statistics were missing or out- of-date, then once the statistics collection is complete, you should return to the Overview tab and rerun the cases, because the characteristics of the column may have changed, so the hints to improve performance would also change. |
Scroll Ignore |
---|
scroll-pdf | true |
---|
scroll-office | true |
---|
scroll-chm | true |
---|
scroll-docbook | true |
---|
scroll-eclipsehelp | true |
---|
scroll-epub | true |
---|
scroll-html | true |
---|
|
Automate SQL tuning and profiling with SQL Query Tuner. Newtabfooter |
---|
alias | IDERA |
---|
url | http://www.idera.com |
---|
| | Newtabfooter |
---|
alias | Products |
---|
url | https://www.idera.com/productssolutions/sqlserver |
---|
| | Newtabfooter |
---|
alias | Purchase |
---|
url | https://www.idera.com/buynow/onlinestore |
---|
| | Newtabfooter |
---|
alias | Support |
---|
url | https://idera.secure.force.com/ |
---|
| | Newtabfooter |
---|
alias | Community |
---|
url | http://community.idera.com |
---|
| | Newtabfooter |
---|
alias | Resources |
---|
url | http://www.idera.com/resourcecentral |
---|
| | Newtabfooter |
---|
alias | About Us |
---|
url | http://www.idera.com/about/aboutus |
---|
| | Newtabfooter |
---|
alias | Legal |
---|
url | https://www.idera.com/legal/termsofuse |
---|
|
|