active newest hottest most voted
Questions in topic: index
0
votes
1
answers
58
views

What indexes should I add to odsstaging to improve the performance of this query

Feb 19 at 08:58 PM SDyckes2 96
0
votes
0
answers
114
views

How can one turn an index scan into a seek?

Jan 17 at 09:25 AM Hugo Kornelis 226
0
votes
1
answers
37
views

Why is this query causing the execution plan to include tables NOT in the query itself?

Dec 21, 2017 at 07:04 PM Aaron Bertrand ♦ 1.7k
0
votes
0
answers
39
views

Usage of three index for the same table

Nov 27, 2017 at 03:46 PM Thomas Franz 16
0
votes
1
answers
57
views

How should i optimize this query

Oct 10, 2017 at 07:59 PM SDyckes2 96
0
votes
0
answers
69
views

what indexes to apply/drop

Jun 08, 2017 at 12:17 PM Aaron Bertrand ♦ 1.7k
0
votes
0
answers
801
views

I can’t see Index Analysis

Jun 08, 2017 at 12:03 PM Aaron Bertrand ♦ 1.7k
0
votes
1
answers
1k
views

index scan vs index seek, how it determine the cost

Apr 11, 2017 at 09:32 PM Aaron Bertrand ♦ 1.7k
0
votes
0
answers
51
views

what suggestion to tune this query or create index?

Mar 09, 2017 at 05:04 PM Aaron Bertrand ♦ 1.7k
0
votes
1
answers
71
views

how can I reduce the cost of sorting prior to aggregate?

Nov 16, 2016 at 03:38 AM SQLkiwi ♦ 6.6k
1
votes
1
answers
184
views

possible to get MAX() with only an index scan?

Oct 09, 2016 at 03:57 PM sam.bishop 54
0
votes
1
answers
83
views

What is the appropriate Index defnition to get rid of the sort operation?

Sep 14, 2016 at 04:06 AM SQLkiwi ♦ 6.6k
0
votes
2
answers
249
views

Index Analysis never completes

Sep 09, 2016 at 01:34 PM gbritton 93
0
votes
2
answers
1.1k
views

Why is the index not seeking?

Sep 06, 2016 at 04:03 PM SQLkiwi ♦ 6.6k
0
votes
0
answers
366
views

How can I reduce the overhead of the Index Seek cost on the Non-Clustered Index

Aug 02, 2016 at 04:04 PM Aaron Bertrand ♦ 1.7k
0
votes
0
answers
107
views

this query is taking too long, any ideas how to improve performance with indexes

Jul 21, 2016 at 08:28 PM Louie.Al 1
0
votes
0
answers
1.4k
views

Any advice on this query

Jul 20, 2016 at 04:53 PM TDK1964 1
0
votes
1
answers
91
views

Help with removing the sort form the plan

Apr 08, 2016 at 03:17 AM Matak 14
0
votes
0
answers
409
views

Am I missing anything obvious while tuning this query ?

Jan 15, 2016 at 01:19 PM sqlzees 1
1
votes
2
answers
97
views

Wrong index scan

Jan 02, 2016 at 11:09 AM SQLkiwi ♦ 6.6k
0
votes
0
answers
89
views

Specific query block our invoice process

Dec 28, 2015 at 03:59 PM Aaron Bertrand ♦ 1.7k
0
votes
1
answers
77
views

How can I optmize this query?

Dec 21, 2015 at 01:29 PM Anonymous User 16
0
votes
2
answers
99
views

SQL Server execution plan is using PK instead of index

Oct 09, 2015 at 06:13 PM Juliano 16
1
votes
2
answers
124
views

Index not being used

Jul 07, 2015 at 04:43 PM Peachy 16
0
votes
0
answers
65
views

Do I need an index for a table that is used by a trigger and monitor?

Jun 29, 2015 at 06:18 PM Peachy 16
0
votes
0
answers
711
views

Difficulty finding covering index for this

May 23, 2015 at 09:29 AM SQLkiwi ♦ 6.6k
0
votes
1
answers
143
views

Any idees how to get better performance for this query, it's a vendor app I cant change the query just indexes, statistics and plan guide.

Apr 07, 2015 at 08:05 AM Hans 6
0
votes
0
answers
265
views

How to solve SQL Deadlock on index

Mar 10, 2015 at 02:07 PM Aaron Bertrand ♦ 1.7k
0
votes
1
answers
481
views

SQL is ignoring my index hint and using a clustered index.

Jul 15, 2014 at 02:11 PM Edward Norris 96
-1
votes
0
answers
301
views

[Closed] indexing problem after implicit conversion in sql server 2005

Oct 25, 2013 at 04:19 AM SQLkiwi ♦ 6.6k
1
votes
1
answers
618
views

Can anybody think of a way to optimise the Sorts in the plan attached?

May 07, 2013 at 02:22 PM SQLkiwi ♦ 6.6k

posts per page 15 30 50

31 Questions
22 answers

Most relevant questions

Tags