Reputation: 4708

Fetching the complete results in sqldeveloper

How do I get the entire query executed in sqldeveloper, which would give me the time taken for execution?

As of now, it just fetches 50-100 rows, and fetches the rest as and when I scrolled down.

It must be a fairly simple solution, but googling it didn't help me. It would be great if someone could point me in the right direction.

Upvotes: 2

Answers (3)

Reputation: 4004

If you want pure query run-time metrics, i.e. not the time to fetch the rows to you client/sqldeveloper, you can use the following:

set timing on set autotrace on select * from ( {YOUR QUERY} ) where rownum = 0;

Upvotes: 0

Reputation: 1674

Upvotes: 1

Reputation: 13496

Click in your result grid and press Ctrl-End.

Upvotes: 1