How can I remove these tables scans? I been adding all kinda index to this tables and the execution plan still uses scans insted of seek Can anyone tell me what I'm doing wrong
By Marekx371 1 asked Oct 05 at 06:51 PM
Hi, it looks like you have a very complex query inside view
You are only pulling 7 columns out of that view so you should look at the query behind this view and look at the possibility of creating a more selective view for this particular use case. Also by being more selective in your view the SQL Server optimizer may uncover some index optimization for you.
By bizkit 16 answered Oct 11 at 05:19 PM