Toad World® Forums

Strange syntax of Execution Plan

Last beta version of TOAD SS 6.0.0.229.
I connect to a DB and write a simple select statement.
In this statement I use a view that I preiously created.
I execute it and switch to - Execution Plan - tab.

I 'm confusing. See Execution Plan 1 for details.
What's this strange characters - a2eival....... - etc,etc,...
Probably the elaboration of your view.

It's not more simple translate these strange charaters {SELECT * FROM TICKETS} a2eival.... to
name of View ?

Probably is more readable and user friendly than these strange characters...

What's do you think of this ?

Best regards.

Sergio Bertolotti

Hi Sergio,
you are right - it is b/c of using ToadViews in your query. I’ve created CR108490 to track this issue.

Thanks for your input.

Hi Alexander,

many thank’s for the CRXXXXX.

Best regards.

Sergio Bertolotti

Last beta version of TOAD SS 6.0.0.299 and the problem is still present.

Best regards.

Sergio Bertolotti

Hi Alexander,

the problem is still present in the last official release of TOAD SS 6.0.

Best regards.

Sergio Bertolotti

Hi Sergio,

It will be fixed in TSS 6.1.

Tha strange name is simply an alias and we need it there and it has to be unique. That’s why it was generated in such way.

To make it a little bit more user friendly now we generate the alias as Toad View Name plus 8 “strange” characters.

regards, Julia.

Dear Julia,

excuse me for the delay.

Many thank’s for your help and clairification.

Best regards.

Sergio Bertolotti