Home
Q & A
login
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
query plan
plan explorer upload
tuning
index
sql server
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
query plan
plan explorer upload
index
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
query plan
plan explorer upload
execution plan
index
0
votes
0
answers
39
views
Usage of three index for the same table
Nov 27, 2017 at 03:46 PM
Thomas Franz
16
query plan
plan explorer upload
index
query-plan
0
votes
1
answers
57
views
How should i optimize this query
Oct 10, 2017 at 07:59 PM
SDyckes2
96
query plan
plan explorer upload
index
query
0
votes
0
answers
69
views
what indexes to apply/drop
Jun 08, 2017 at 12:17 PM
Aaron Bertrand ♦
1.7k
query plan
plan explorer upload
index
clustered index
tables
0
votes
0
answers
801
views
I can’t see Index Analysis
Jun 08, 2017 at 12:03 PM
Aaron Bertrand ♦
1.7k
query plan
plan explorer upload
poor performance
index
sql sentry
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
query plan
plan explorer upload
index
scan
seek
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
query plan
plan explorer upload
index
tune query
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
query plan
plan explorer upload
index
sort
aggregate
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
query plan
plan explorer upload
execution plan
performance
index
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
query plan
plan explorer upload
index
row_number
sort operation
0
votes
2
answers
249
views
Index Analysis never completes
Sep 09, 2016 at 01:34 PM
gbritton
93
query plan
plan explorer upload
index
sql sentry
0
votes
2
answers
1.1k
views
Why is the index not seeking?
Sep 06, 2016 at 04:03 PM
SQLkiwi ♦
6.6k
query plan
plan explorer upload
index
scanvsskeen
seeking
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
query plan
plan explorer pro upload
index
sql server
non-clustered
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
query plan
plan explorer upload
index
query
optimize
0
votes
0
answers
1.4k
views
Any advice on this query
Jul 20, 2016 at 04:53 PM
TDK1964
1
query plan
plan explorer pro upload
performance
index
statistics
0
votes
1
answers
91
views
Help with removing the sort form the plan
Apr 08, 2016 at 03:17 AM
Matak
14
query plan
plan explorer upload
execution plan
tuning
index
0
votes
0
answers
409
views
Am I missing anything obvious while tuning this query ?
Jan 15, 2016 at 01:19 PM
sqlzees
1
query plan
plan explorer pro upload
performance
tuning
index
1
votes
2
answers
97
views
Wrong index scan
Jan 02, 2016 at 11:09 AM
SQLkiwi ♦
6.6k
query plan
plan explorer upload
index
parameter sniffing
0
votes
0
answers
89
views
Specific query block our invoice process
Dec 28, 2015 at 03:59 PM
Aaron Bertrand ♦
1.7k
query plan
sql
sql sentry upload
index
plan
0
votes
1
answers
77
views
How can I optmize this query?
Dec 21, 2015 at 01:29 PM
Anonymous User
16
query plan
plan explorer upload
execution plan
index
sort step
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
query plan
plan explorer upload
execution plan
index
clustered index
1
votes
2
answers
124
views
Index not being used
Jul 07, 2015 at 04:43 PM
Peachy
16
query plan
plan explorer pro upload
index
missing index suggestion
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
query plan
plan explorer pro upload
index
heap
trigger
0
votes
0
answers
711
views
Difficulty finding covering index for this
May 23, 2015 at 09:29 AM
SQLkiwi ♦
6.6k
query plan
plan explorer upload
index
clustered index scan
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
query plan
plan explorer pro upload
index
statistics and plan guide tuning
vendor app
0
votes
0
answers
265
views
How to solve SQL Deadlock on index
Mar 10, 2015 at 02:07 PM
Aaron Bertrand ♦
1.7k
plan explorer pro upload
sql
index
deadlock
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
query plan
plan explorer upload
index
clustered
hint
-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
query plan
plan explorer upload
index
implicit conversion
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
query plan
plan explorer upload
index
sort order
posts per page
15
30
50
Search Q & A
ask a question
Where to?
Questions
Tags
Users
Badges
Unanswered
31
Questions
22
answers
Most
relevant
questions
Tags
query plan
× 676
plan explorer upload
× 489
plan explorer pro upload
× 166
execution plan
× 124
poor performance
× 115
performance
× 91
tuning
× 49
sql
× 42
sql sentry upload
× 38
index
× 31
query-plan
× 30
clustered index
× 25
sort
× 25
statistics
× 24
sql server
× 23
query
× 21
deadlock
× 15
sql sentry
× 15
optimize
× 9
plan
× 8
clustered index scan
× 6
implicit conversion
× 4
scan
× 4
seek
× 4
parameter sniffing
× 3
row_number
× 3
aggregate
× 2
non-clustered
× 2
sort order
× 2
clustered
× 1
heap
× 1
hint
× 1
missing index suggestion
× 1
scanvsskeen
× 1
seeking
× 1
sort operation
× 1
sort step
× 1
statistics and plan guide tuning
× 1
tables
× 1
trigger
× 1
tune query
× 1
vendor app
× 1