Collect Statistics.

Database
Fan

Collect Statistics.

Hi Friends,

How collect statistics improve performance of a query?

Regards,
Rakesh
1 REPLY
WAQ
Enthusiast

Re: Collect Statistics.

Statistics provides assistance to optimizer to choose the best plan for execution of the request/query. Without statistics optimizer would not be aware of certain important poimts that should be known before executing the query.