vb.net + SQL 's store procedure

  • Thread starter Thread starter Agnes
  • Start date Start date
A

Agnes

I run a simple SP in through my vb.net program.
Does any way I can read the "execution Plan" ???

Or. I need to read it by using SQL anaylzer ?, thanks
 
Agnes,

A SP has only a very small effect on your VBNet application

While it is almost not important.

The only thing you tell in that application that the SQL strings are not
provided by the program however by the stored procedures.

For the rest everything is the same.

I would forever go for first (in the develloping process) use the SQL
strings in my program and than at production time change them (place them
in) for stored procedures. That gives me the most flexibility.

I hope this helps?

Cor
 
Back
Top