First page Back Continue Last page Overview Graphics

Workshop

Dynamic Sampling

Notes:

Dynamic Sampling Workshop
Execute the supplied script: dynamic_sampling_prep.sql
Execute the following query with and without a dynamic sampling hint. Note the differences in the execution plans.
SELECT t2.object_name, t2.object_application, t1.created
FROM t1, t2
WHERE t1.object_id = t2.object_id;
Execute the supplied script: dynamic_sampling_reset.sql