The below query is used for optimization. The query execution plan will make use of the statistics created. Is that the satistics created for all the columns in the table (OR) only for the indexed columns. Statistics created ? What it is actually meant ? What it does for statistics creation ?
Please explain the below query :
analyze table test estimate statistics sample 2500 Rows;