sql server 2008 interpret statistics

enrique_aeo
enrique_aeo used Ask the Experts™
on
hi experts, I made inquiries:
1. On a table with no index and create their statistics
2. Then create sign and went back to check your statistics
Could help interpret statistics

2.-SIN-INDICE-estadisticasRESULT.jpg
2.-CON-INDICE-estadisticasRESULT.jpg
1.-estadisticasDEFINICION.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Topic Advisor, Page Editor
Distinguished Expert 2018
Commented:
Sounds a bit like a homework / exam question. Which is fine, but we need to guide you through - to help clear up any misunderstandings, to edcuate, not to answer it specifically (as part of academic honesty). If it is not homework, then it is quite an intersting puzzle you have.

What is the difference between the trials ?

What kind of "interpretation" of statistics - is there meant to be a recommendation as to which trial is best ?

From what I can see there is a single select returning 13 rows with Trial 1 being off the planet and trials 5 and 9 looking the best.

How can we help you with this ?

Author

Commented:
I just want to see what the theory says. A graph is to index and other graphic is no index. parameter that must guide me to know that it has improved

Author

Commented:
please, can you give me some url to start seeing this issue

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial