CODEWITHSUNDEEP
sqlsql-servert-sqlquery-optimization
Sudantha
Sudantha

Reputation: 16204

What really 'STATISTICS' do?

What really STATISTICS do? and where to use in query optimization which senarios?

Upvotes: 1

Views: 186

Answers (2)

Alan here
Alan here

Reputation: 1

one example i use: after creating an index on the table i do

dbcc dbreindex(table)
update statistics table

after that the optimizer might actually start using the index.

Upvotes: 0

RichardTheKiwi
RichardTheKiwi

Reputation: 107716

You do not manually use statistics. SQL Server's query optimizer does. It is used to determine if and which indexes will help a query.

At this point, I recommend you start with reading some basics:

Upvotes: 6

Related Questions