An analytics team uses a multibillion row table that is relevant to a great number of queries with
different filters and joins. The Administrator needs to identify an effective strategy to collect statistics
on this table.
Which statistics should be collected?
An analytics team uses a multibillion row table that is relevant to a great number of queries with
different filters and joins. The Administrator needs to identify an effective strategy to collect statistics
on this table.
Which statistics should be collected?
A business' operating periods are event-driven, and the batch window begins and ends at various
times of the evening. The Administrator needs to configure TASM to dynamically trigger the
reporting planned environment using an API call issued when the batch window ends.
Which type of event can the Administrator use to meet this requirement?
After a recent migration, a request has started to take significant time to complete. Upon a detailed
investigation of the EXPLAIN plan, it is found that an accidental unconstrained product join on a very
uniformly-distributed large table was the prime reason for the issue. The Administrator needs to use
workload management to detect when this request is running.
Which criteria should the Administrator select for this issue?