SQL-Window: Statistics Tab

[ed10k]

Statistics-Tab at SQL-Window:

1. Right-Click / Export / "SQL file": the sql-file does insert the statistics into a table which are selected :-(

2. Ctrl-F works, but Ctrl-L doesn't work.

3. Can you filter the output in this tab? For example I would like to see all lines with Name like '%CPU%' and after it all lines with Name like '%parse%' etc.
Or I would like to see all statistics where Last > 0 or Last > 100 etc. And the same with Total.

4. Export to Excel where helpful too.

5. Generally export to Excel were very helpful at all grid-windows of entire PLSD (Explain Window inclusive).

Thanks

Eduard

 

[Marco Kalter]

1. Right-Click / Export / "SQL file": the sql-file does insert the statistics into a table which are selected :-(

2. Ctrl-F works, but Ctrl-L doesn't work.

We'll fix it.

3. Can you filter the output in this tab? For example I would like to see all lines with Name like '%CPU%' and after it all lines with Name like '%parse%' etc.
Or I would like to see all statistics where Last > 0 or Last > 100 etc. And the same with Total.

No, this is currently not possible. You would first need to export to CSV and open it in Excel.

4. Export to Excel where helpful too.

5. Generally export to Excel were very helpful at all grid-windows of entire PLSD (Explain Window inclusive).

I have added this (and point 3) to the list of enhancement requests.