In this video we will explain how to work with window find -> SQL
In many cases we have to search for specific query,
where we can determine for example part of used text,
or we know Plan Hash Value.
We can make a demonstration were we are interested in Plan Hash Value.
We make copy Cell.
Zero means for all queries.
We can remove SQL Text and begin search.
Speed of search depends on speed of your database
and of course on background processes.
In case you are searching using SQL text the operation can be time-consuming.
You have to be patient,
because we are running full scan of all saved queries
and we are searching for specific text string.
We can see different columns which are displaying for the queries,
how many rows were processed, how many times the query was executed,
Elapsed time for all executions and elapsed time per execution.