I have a query that once put directly into the Query Analyzer takes 1 second while using my Index Views. This is extreamly fast.
If i put the same query inside a stored procedure and execute the stored procedure inside of Query Analyzer it takes over 30 seconds!!
the stored procedure uses a completely different execution plan? It is like it isn't reading the statistics or something. thanks.
I have cleared the bufferes the cache, updated the statistics... same rsults. I have had this happen on multiple queries. Where once put into a SP it slows down tramindisly. Note: This is also in the query analyzer (just calling the SP)