CREATE TABLE [dbo].[Trade](

[NetAmount] [decimal](18, 4) NULL DEFAULT ((0.00)),

[Instrument] [varchar](50) NULL DEFAULT (''),

[Status] [varchar](max) NULL DEFAULT (''),

[TransactionDate] [datetime] NULL DEFAULT (getdate()),

[Rate] [decimal](18, 4) NULL DEFAULT...

Lynn Pettis (3/15/2012)

---

I see things in the code that may be forcing table scans. The use of NOT IN and <> in the WHERE clauses of a couple of...

Hi,

Thanks for the reply.

Please find the attached Execution Plan in sqlplan format (its not permitting me to upload xml file), and the original query.

It took more than 4...