New statistics

Question

New statistics

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
July 9, 2019 at 12:00 am

#3658991

Comments posted to this topic are about the item New statistics

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72498 More actions · Answer 1

Good question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Uwe Ricken Hall of Fame Points: 3142 More actions · Answer 2

Hi Steve,

I trapped into the pitfall and didn't see that the last query was not using any predicate 🙂

If you use a query with a predicate it will create a statistics object automatically (in your scenario)

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

Rune Bivrin SSCrazy Eights Points: 8440 More actions · Answer 3

Hush! That's probably for an upcoming QotD...

Just because you're right doesn't mean everybody else is wrong.

dotathinker SSC Enthusiast Points: 133 More actions · Answer 4

Also if you have case sensitive collation, you spell ages with both uppercase letter and lowercase letter. That would also return 0 rows.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 5

Good catch. I never run case sensitive, but edited the question.

TomThomson SSC Guru Points: 104773 More actions · Answer 6

The explanation is somewhat broken - it says that if you query the table you will generate stats data. Well, you did query the table, and you didn't generate any stats data. The explanation should say that to make stats data by querying the table you have to have some meaningful condition in your query.

But I didn't know that, so I've learnt something from the question anyway.

Tom