Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 |
