Toad World® Forums

Explain plan bug


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.

/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.



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