It's all about the orders table. If you'll notice, the 'good plan' does a seek on the track index, then does a lookup and then does clustered seek against...

Don't worry about that as much. I...

Need to see the build script and DDL to truly answer your question, or at least...

Frank Nadal (11/23/2010)

---

Oops, sorry for the icons, next time I'll edit that properly.

Yes yes. I'm looking at the graphical plan and the clustered index scan on that bad plan produced...

CREATE TABLE auData

(

auID NUMERIC, -- This column will have Unique value always

Emp_ID NUMERIC,

dt_Start DATETIME,

dt_End DATETIME,

Emp_Cat INT

)

Go

INSERT INTO auData VALUES(3037,1,'2010-11-18 11:36:34.210',NULL,1)

GO

INSERT INTO auData VALUES(3038,1,NULL,'2010-11-18 11:49:00.917',1)

GO

INSERT INTO auData VALUES(3039,1,'2010-11-18 15:15:04.590',NULL,1)

GO

INSERT INTO auData...

Of note:

| |--Clustered Index Seek(OBJECT[WINTRACK_NLA].[dbo].[orders].[ORDERS_PK_C] AS [o]), SEEK[o].[o_num]=[t].[o_num]), WHERE(Convert([o].[o_type])=30 OR Convert([o].[o_type])=9) AND ((([o].[trn_id]=0 OR [o].[trn_id]=25

| | |--Clustered Index Scan(OBJECT[WINTRACK_NLA].[dbo].[orders].[ORDERS_PK_C] AS [o]), WHERE(Convert([o].[o_type])=30 OR Convert([o].[o_type])=9) AND ((([o].[trn_id]=0 OR [o].[trn_id]=25) OR [o].[trn_id]=45)...

Heh, to make life easier, can you edit that post and wrap the plans in the code="plain" shortcuts you'll see on the left? Just highlight the section and click...

Alvin Ramard (11/23/2010)

---

CirquedeSQLeil (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Stefan Krzywicki (11/23/2010)

---

Craig Farrell (11/23/2010)

---

Stefan Krzywicki (11/23/2010)

---

I like the WROX Press books. I'm in for 2 13 hour train rides this holiday and I'll be...

It's rare to get a serious issue still in the 2k environments, so to confirm, you meant to post in the SQL 7/2k forum, right? If so, which are...

My word, Alvin......

GSquared (11/23/2010)

---

No, I don't. We've already agreed on that. (Of course, the very statement that I avoid humor...

GSquared (11/23/2010)

---

If you want, I'll put the whole thing into article form and give it to Steve. Probably should have done that a year ago, when I got it...

GSquared (11/23/2010)

---

Along with my missing backups alert, I also get a list of all disabled jobs, including the last time they were run. It also includes scheduled jobs that...

Stefan Krzywicki (11/23/2010)

---

I like the WROX Press books. I'm in for 2 13 hour train rides this holiday and I'll be bringing the SSIS, SSAS and SSRS books along for...

CirquedeSQLeil (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

CirquedeSQLeil (11/23/2010)

---

GilaMonster (11/23/2010)

---

CirquedeSQLeil (11/23/2010)

---

If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what...