See above, Gail. You'll remember the...

Brandie Tarvin (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your...

EasyBoy (4/16/2014)

---

ChrisM@Work (4/16/2014)

---

Did you look at the execution plans to see if...

Greg Edwards-268690 (4/22/2014)

---

Ed Wagner (4/22/2014)

---

dwain.c (4/21/2014)

---

Greg Edwards-268690 (4/21/2014)

---

TomThomson (4/20/2014)

---

Fillet "a fish"...

TomThomson (4/18/2014)

---

Lynn Pettis (4/18/2014)

---

TomThomson (4/17/2014)

---

I may be confused here, but if I've understood correctly the optimiser might be able to do somewhat better with an index like this:-

CREATE NONCLUSTERED INDEX...

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

You need to do further research before you change the existing index to a filtered index, because that index will no longer satisfy queries originally using it...

What are the business rules?

Except...the 70k read plan isn't from the index Gail suggested, and whatever index it is has several columns which aren't referenced by the query - hence the difference in reads.

I'd...

Like this?

SELECT

KeyValue,

Flag4 = MAX(CASE WHEN ItemNumber = 4 AND Flag =...

CONVERT takes a style parameter which can be used to shape the output of a date-datatype to string-datatype conversion - which is the usage that most folks are familiar with....

Thanks! That's nice - the filtered index eliminates the need for an expensive residual predicate (the "filter" bit of the filtered seek Gail mentioned...

Try to obtain the same result set by whatever other means you can think of. Time the execution of each method and record those timings. Usually the fastest query is...

GilaMonster (4/16/2014)

---

The query is reading just over 14 million rows and aggregating that down to 1099. If it's reading 14 million rows from a table (the rows which satisfy the...

You're retrieving 14+ million rows from one index or another on a...

yuvipoy (4/15/2014)

---

ChrisM@Work (4/15/2014)

95% of the cost of the query is a key lookup of table2. The query uses index IDX_SE_CD_MEAS_FK to seek matches on column TCOL1. Since the output requires...