Toad World® Forums

how to search by "Plan hash value"?


#1

Hi,

when u have, let’s say, 200 scenarios, then you need to search quickly amount them.

for instance tuning task find something and shows better plan, but there you see only plan and hint…and would like to find real query, if is existing in SQL optimizer.

also, ask yourself…how do you manage 200 scenarios? how to reference them later or in any analyze?

Only by plan value!

So please, place that value in Grid and allow to be at least sort by column, if search is not possible.

Brg

Damir


#2

To place a column to grid for plan value, which is simple. However, we think it can be more than that. If you can show us a user case, it will be very helpful to make a completely feature design. Please provide a detail about how would you like to use the “Plan Hash Value”.

Thanks,

Tony Ng


#3
  1. put a column in a grid

  2. allow to be sorted and search by this column.

Brg,**
________________________**

Damir Vadas
http://damir-vadas.blogspot.com

Life begins after the 50’s - until then it’s just a research!
Život počinje poslije 50-te-sve do onda je samo istraživanje!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Tue, Jun 5, 2018 at 6:16 AM, TonyNg bounce-TonyNg@toadworld.com wrote:

RE: how to search by “Plan hash value”?

Reply by TonyNg
To place a column to grid for plan value, which is simple. However, we think it can be more than that. If you can show us a user case, it will be very helpful to make a completely feature design. Please provide a detail about how would you like to use the “Plan Hash Value”.

Thanks,

Tony Ng

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from SQL Optimizer for Oracle Forum notifications altogether.

SQL Optimizer for Oracle - Discussion Forum

Flag this post as spam/abuse.


#4

serach can be assigned with “Ctrl+F” on header of column or right clik on column (anywhere in the grid)…Similar like Toad has

Brg,**
________________________**

Damir Vadas
http://damir-vadas.blogspot.com

Life begins after the 50’s - until then it’s just a research!
Život počinje poslije 50-te-sve do onda je samo istraživanje!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Tue, Jun 5, 2018 at 8:02 AM, Damir Vadas damir.vadas@gmail.com wrote:

  1. put a column in a grid
  1. allow to be sorted and search by this column.

Brg,**
________________________**

Damir Vadas
http://damir-vadas.blogspot.com

Life begins after the 50’s - until then it’s just a research!
Život počinje poslije 50-te-sve do onda je samo istraživanje!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Tue, Jun 5, 2018 at 6:16 AM, TonyNg bounce-TonyNg@toadworld.com wrote:

RE: how to search by “Plan hash value”?

Reply by TonyNg
To place a column to grid for plan value, which is simple. However, we think it can be more than that. If you can show us a user case, it will be very helpful to make a completely feature design. Please provide a detail about how would you like to use the “Plan Hash Value”.

Thanks,

Tony Ng

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from SQL Optimizer for Oracle Forum notifications altogether.

SQL Optimizer for Oracle - Discussion Forum

Flag this post as spam/abuse.