Toad World® Forums

Explain plan bug


#1

Hi guys,

I guess this isn’t really a bug with the beta since it’s also in V5, but I thought I’d mention it anyways.

When using the explain plan tool it’s not currently possibly to comment out a block of sql. For example, if you paste this into the tool and click Generate, you will get an error about the comment not being properly terminated.

SELECT* FROM dual
/WHERE 1=1/

The “–” will work, but for big blocks this isn’t very convenient. It would really help the way I work (when diagnosing performance issues) to be able to easily comment out big blocks of the query at a time.

DK


#2

Hi kridan,
Yes I think it is a bug, it was signed a long time ago on this community.

-Piter-