Cant elimintated these Index Scan

I have this Proc that pulls that from a view which is made out of other view, and I cant eliminate these index scans that I have 89 of and 36 clustered scans, anyone can tell me what i missing, I different types of Indexes but it still usuing a scan

11.pesession (330.7 kB)
avatar image By Marekx371 1 asked Oct 16 at 09:02 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

Not all index scans are a bad thing. There are times an index or table scan will do less work than an index seek.

When tuning your query look at the Top Operations tab to find the highest cost operator, in this case, it is an Index Seek on the [saAdmin].[dbo].[Products.By.Site].[idx_pbs_SiteID].(NonClustered). The next highest costs are for the Hash Match (Inner Joins). Then look for the largest pipe, both the number of records and the size of the data. Look for ways to decrease the size of the perspective pipe.

Since you have provided an estimated plan, it is hard to provide direction on the further tuning of the query.

avatar image By SDyckes2 81 answered Oct 17 at 01:58 AM
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:

x641
x455
x117
x4
x4

asked: Oct 16 at 09:02 PM

Seen: 24 times

Last Updated: Oct 17 at 01:58 AM