Home >> Dot Net Interview Questions >> Mix Dot Net Questions

Can it is possible see SQL plan in textual format

Posted on May 30th , 2009 by Admin

Yes we can saw the textual plan in SQL by just "set showplan_text on" after doing this we will saw the textual plan in past we will use "SHOWPLAN" the syntax is quite simple

set showplan_text on

select * from tablename