We are using both views and indexed views in our application but lately we are seeing that sql server is not using optimized plan for a query that involved view and if i use force order hint or try to use inline view it works fine. I am wondering if someone else also seen this behaviour in application and what method use to avoid such optimal plan except not using views:)
View performance problem
Posted - 01/09/2004 : 14:10:57
