Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-01-09 : 14:10:57
|
Hi,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:) Thanks--rubs |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-09 : 14:43:53
|
Are your indexes fragmented? To see this, run DBCC SHOWCONTIG. To fix, run DBCC DBREINDEX.Tara |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-01-09 : 15:12:37
|
1) no indexes are fragmented2) statistics are run on all tables and indexed views with fullscanThanks--Harvinder |
|
|
|
|
|