Examine this command: Which three statements are true about the effect of this command?
A.
Any existing statistics for the CUSTOMERS table are still available to the optimizer at
parse time.
B.
Statistics gathered on the CUSTOMERS table when schema stats are gathered are
stored as pending statistics.
C.
Statistics collection is not done for the CUSTOMERS table when database stats are
gathered.
D.
Statistics collection is not done for the CUSTOMERS table when schema stats are
gathered.
E.
Statistics gathered on the CUSTOMERS table when database stats are gathered are
stored as pending statistics.
Answer is A,B,E
ABE