Thanks guys, the difference in speed is amazing 🙂

The first one

CREATE NONCLUSTERED INDEX idx_Transactions_TransTime

ON dbo.transactions (trans_time, SiteID)

INCLUDE (transactionID,siteID,areacode,gamename,sitename)

GO

is reporting

Msg 1909, Level 16, State 2, Line 1

Cannot use duplicate column names in index. Column name 'SiteID' listed more than...

wow thanks for this, adding these, will not effect the table data will it, the last thing i need is to mess up the database lol

right got it, its attached, thanks for the help 🙂

GilaMonster (6/23/2015)

---

I need to know what indexes exist on the tables involved in this query.

Open up Management Studio, navigate in Object Explorer to the tables and script out the...

Attached is the sqlplan, not sure how to get the other info you wanted.

GilaMonster (6/22/2015)

---

Err, there's no such version as SQL 2003.

You mean SQL 2005?

See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ for saving execution plans.

For the index definitions, you can see them in Management Studio, should be same...

I'm not ofay on how to do this, i'm not a SQL developer i come from an embedded software...