sql code works fine - front end application is slow?

Question

sql code works fine - front end application is slow?

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

mmarovic SSC Enthusiast Points: 160 More actions · Answer 1

Lowell (3/4/2011)
an execution plan gets created when the procedure is created,as everyone probably knows.

I still use SQL Server 2000 and for that version execution plan is created when the procedure is executed if its execution plan is not already cached. I don't know for later versions, but I doubt it has changed.