Question

Oracel Database:

Execute dbms_stats.gather_schema_stats(user); Select table_name, blocks from user_tables; What does this tell you about basic compression and DML?

Answer 1

The first line of the code,

Execute dbms_stats.gather_schema_stats(user);

Is used for gathering statistics of the given data and reduce it into a small fragment of data so that any operation can be performed without any overhead.

Then, the second line

Select table_name, blocks from user_tables;

Is used to select values such as table_name and blocks from the user_table which was executed in the above query and boiled down to a smaller set of data so that values can be fetched easily.

Therefore the given code will execute the user table and make the data as less as possible and then execute select query to fetch the defined data quickly.

If you liked the solution then give a thumbs up ? it will be really appreciated ?