How can i remove these table scans ?

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

5.queryanalysis (367.6 kB)
avatar image By Marekx371 1 asked Oct 05 at 06:51 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

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.

avatar image By bizkit 16 answered Oct 11 at 05:19 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x631
x445
x4
x3
x1

asked: Oct 05 at 06:51 PM

Seen: 24 times

Last Updated: Oct 11 at 05:19 PM