How can i remove these table scans ?

Marekx371 2017-10-05 18:51:15

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

bizkit 2017-10-11 17:19:14
Hi, it looks like you have a very complex query inside view

Products.Alerts.Kid.QOH.Higher.Than.0.And.Parent.QL.Is.0

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.