Search code examples
sqlplsqlplsqldeveloper

Query execution time in PL/SQL Developer

I'm running queries in PL/SQL Developer. How to find out the running time of sql query in PL/SQL. I am querying specific tables. Like

select * from table_name where customer_id=1;

select * from movie_table where movie_id=8;

While i am using PL/SQL, i want to know the query running time.

Thanks, your help is very much appreciated.

Solution

  • The simplest way to do this, courtesy of @Hamidreza's link, is like this:

    set timing on;
select * from table_name where customer_id=1;

    The execution time will appear below the records selected.