- Why do we collect stats?
- How stats collection improve the performance?
- Does the execution plan of an already running load gets changed after stats gathering?
- stats export and stats comparison
- Will there be different plans when there is parallel execution?
- Can the stats become stale when only read happens? - No
- Stats get stale when more than 10% of the data gets modified.
- How frequently stats have to be collected?
Ref:
No comments:
Post a Comment