This is a note to my trainee miss Jansen,
That´s the way you can find what objects you need to create statistics after you made a lot of changes on schema
LAST_DDL_TIME
SQL> SELECT OBJECT_NAME FROM USER_OBJECTS WHERE LAST_DDL_TIME>SYSDATE-2;
SQL> ANALYZE TABLE X475 COMPUTE STATISTICS;
Table analyzed.
OBJECT_NAME
——————————————————————————–
X475
