Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

You executed the following commands:

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table
in the above session?

You executed the following commands:

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table
in the above session?

A.
The statistics are stored in the pending statistics table in the data dictionary

B.
The statistics are treated as the current statistics by the optimizer for all sessions

C.
The statistics are treated as the current statistics by the optimizer for the current sessions only

D.
The statistics are temporary and used by the optimizer for all sessions until this sessions
terminates



Leave a Reply 0

Your email address will not be published. Required fields are marked *