Yes that fixed it, I also found good information at http://www.sqlservercentral.com/Forums/Topic332162-146-1.aspx

Thank You

I tried that and it gives me the same error.

I USED THIS SELECT AND IT HAD ALL THE INFORMATION I NEEDED

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'YOUR_TABLE_NAME' ORDER BY COLUMN_NAME

THANKS

Column Name, field type, length

I have just uploaded the results from running sys.dm_db_missing_index_group_stats

is this is bad as it looks I am really not sure how to read it yet.

I know I am asking a...

I really do not know what this means but I have uploaded a file with the results of

select * from sys.dm_db_missing_index_details

The query was created and is maintained in peoplesoft query manager.

Peoplesoft Enterprise

Finance

PeopleSoft 9.0 peopletools 8.48 query was created throught the PIA

Table definition Added

STATISTICS TIME

SQL Server parse and compile time:

CPU time = 3119 ms, elapsed time = 3119 ms.

(1841 row(s) affected)

SQL Server Execution Times:

CPU time =...

STATISTICS IO FROM MY PRODUCTION SERVER

Table 'Worktable'. Scan count 5523, logical reads 32808, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads...

Table definition and index definitions please? I do not know how to get these but I am looking and learning.

execution plan add in attachments

I fixed it by adding

AND B.ACTIVE_HOLD_DTTM= (SELECT MAX(MX.ACTIVE_HOLD_DTTM) FROM PS_ORD_HOLD_AUDIT MX

WHERE B.ORDER_NO=MX.ORDER_NO

ND MX.ACTIVE_HOLD_DTTM <= SUBSTRING(CONVERT(CHAR,GETDATE(),121), 1, 10))

to the where statement