In today’s article, we will be examining how we can learn the time of any query we write.
We can learn the time of any operation performed with the following command.
|
1 |
SQL> SET TIMING ON |
After this command, we can now learn the time of the queries we run.
|
1 2 3 4 5 6 7 8 9 10 |
SQL> CREATE TABLE ONUR_DENEME LOGGING AS SELECT * FROM DBA_TABLES; Table created. Elapsed: 00:00:00.96 SQL> CREATE TABLE ONUR_DENEME_2 NOLOGGING AS SELECT * FROM DBA_TABLES; Table created. Elapsed: 00:00:00.64 |
