I was just trying to tune two or three queries that are run thousands of times per day and I knew had issues. There are procedures that are not...

I just double-clicked the SQL plan and it opened in the query analyzer. Not sure what problem you are having.

If you look at my earlier post, I executed all of the statements as a single execution.

The first thing is to drop the table.

Then, I call the select statement that...

I dropped the index that I just created and saved the execution plan. However, that above index seems to be the issue. The SQL execution plan just gives...

I created the index that I got from DTA and execute my query, without the index hint. No missing query. I ran your code. No missing query....

I ran a trace and executed the query and ran that through DTA. The closest index that I found in the results are this. I will try this...

Hmmm...

I commented-out the index hint and ran the execution plan. It does not say that there are any missing indexes.

SELECT

PK

...

Here is what I get for selectivity:

0.0000094580600 ROI_STAGE

0.9689775599620 QC_DATETIME_STARTED

0.0000031526860 INVOICE_STATUS_CODE

Here is my current statement, called in a single query session, with a single execution. You will...

I captured a trace file and I have tried running it through the DTA, but it keeps failing. I have been trying to capture a new trace file, but...

I have been running my select statement in-line with they other statements. I have actually been running it and not just the execution plan. I tried all six...

With your code, I ran the query, and not just the execution plan. The order of the columns was based on what the execution plan told me, but it...

Database DSS_Legacy

Table - tbl_ROI_CATALOG

Equality - [ROI_STAGE], [QC_DATETIME_STARTED], [INVOICE_STATUS_CODE]

Inequality - NULL

Statement - [DSS_Legacy].[dbo].[tbl_ROI_CATALOG]

Included Columns - NULL

Avg Cost - 10.908600269265

Avg Impact - 99.96

Seeks - 2

Scans - 0

Last Scan - NULL

Last Seek...

Originally, I confirmed that it is in SSMS, under the table properties. The column names and order matches what is given in the "missing index" statement. I just...

Thanks.

I ran those statements.

The result listed the following columns, which are the same columns that the execution plan listed:

[ROI_STAGE], [QC_DATETIME_STARTED], [INVOICE_STATUS_CODE]

I have created the following index, several times:

CREATE NONCLUSTERED INDEX...