Execution plan problem

Toad for SQL Server
1

Hi,

I have few problems with Toad for SQL Server Freeware

  1. When I hit “Include actual execution plan for each executed statment” and execute simple query like “select * from my_table” in 2-3 second i have error: “Lookup Error - Single execution returned more than 1 result sets”

  2. When i estimate execution plan for simple query like “select * from my_table” i have completely different plan that i had from SSMS. Namely “Clustered index scan cost = 0%” rather than 100%

Best regards.

2

Hi Iceef,

Thanks for your feedback. In the latest Toad Version ,I was unable to reproduce this issue,

Please try to download the 6.6 Beta. If you still get the error ,Please let me know.

Thanks.

Cathy.