All geek questions in one place

Collects statistics needed after resetting indexes and rebuilding them?

I am using Oracle SQL and I have one question. I have a table with indexes, and it collects statistics. I have a procedure that discards indexes, inserts data into a table, and then recreates the same indexes again. Do I need to collect statistics again after this procedure, or will the indices be recognized? To collect statistics, I use:

EXEC dbms_stats.gather_table_stats(''MIGBUFFER'','''||table_name||''',cascade=>TRUE);
+4
source share
1 answer

No. There is no need to collect index statistics immediately after the index is created , as Oracle automatically collects statistics for indexes at creation time.

,

Oracle .

, , COMPUTE STATISTICS, . . Oracle Database . .

+4

Source: https://habr.com/ru/post/1616697/

More articles:


All Articles